C
Colin Macleod
I have two Excel files which I'm accessing via SharePoint. Some of the cells
in the second file need to be linked to some of the cells in the first file.
Mots of the links are simple - I just want to show the current value of a
particular cell in the other file - but in some cases the value in one file
will be the sum of several cells in the other file. I set up the links by
opening up both files, clicking on a cell in the second file, entering an
equals sign, then clicking on the cell in the first file. The links seem to
be OK if both files are open, but if the first file is closed, then the link
just seems to be to a locally saved version rather than the "real" version.
Any help and advice would be very welcome. Thanks
Colin
in the second file need to be linked to some of the cells in the first file.
Mots of the links are simple - I just want to show the current value of a
particular cell in the other file - but in some cases the value in one file
will be the sum of several cells in the other file. I set up the links by
opening up both files, clicking on a cell in the second file, entering an
equals sign, then clicking on the cell in the first file. The links seem to
be OK if both files are open, but if the first file is closed, then the link
just seems to be to a locally saved version rather than the "real" version.
Any help and advice would be very welcome. Thanks
Colin