Gordon Burgess-Parker wrote:
OO 2 final - I am having tremendous dificulty with links between
spreadsheets. I am assuming that the function works like Excel - you
select the cell, press "=" and then select the cell in the other
spreadsheet. (Someone correct me if this is NOT the way to do it?)
The first problem I have is that when I go to make a link to one
particular sheet, it tells me the spreadsheet I want to link to doesn't
exist! Yet there it is, open, not "untitled" and I'm working on it!
the second major problem I am having is that I make a link to another
sheet, select a cell with data in it, yet the cell that contains the
link returns 0! And autocalc IS on.
It also seems to be very flakey - I've just done the above with a new
empty spreadsheet and it works perfectly OK! Yet the sheet that I need
to set up links in, which was also just created this morning, has all
these problems! Can anyone suggest a reason why the links in THIS
particular spreadsheet sre not working properly?
I can't help with the first problem - I can't reproduce it.
The second problem is probably related to the facts that, firstly the
link is to the saved copy of the "source" file, so any changes made in
this file can't be picked up until it is saved. Secondly, links only
seem to updated when the "receiving" file is opened or reloaded.
So if you had such a link set up, and you wanted to change a cell in the
"source" file and see the change reflected in the "receiving" file, you
would need to:
(1) Save the "source" file
(2) Save the "receiving" file, then do "File - Reload". You will be
asked whether you want your links updated - say yes and they will be.
(There may be another way to force links to be updated, but I haven't
found it.)
This seems rather clunky - but then if the two sheets you are working on
are going to be open at the same time, why not have them within the same
file - then the updating will be automatic? Linking from file to file
seems to be more suited to a situation where you are working on files
at different times (or maybe one file is kept updated by one person, and
the other by a different person). But of course, I don't know your
precise needs.
Anyway, hope this helps a bit.
Andy
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
