Linking Speadsheets

  • Thread starter Thread starter filky
  • Start date Start date
F

filky

Is anyone aware of any issues associated with linking spreadsheets
together on a shared file server?
I have two seperate excel files, one feeding of information from the
other, and the cell calculating data provided from the other file
doesn't update when I make the changes.
The autocalc is turned on in both files.
Has anyone had this issue before?
 
Is this just one pc with both workbooks open at the same time?

If it is, make sure you have both workbooks open in the same instance. If you
actually have two instances of excel open with one workbook open in each
instance, then these updates won't be automatic.

You'll have to save the workbook where you made the change and then in the
workbook with the formula links, you'll have to update the links
(Edit|Links|Update Values).

One way to check to see if you have both workbooks open in the same instance is
to look under Window (on the menubar). You should see both workbook names at
the bottom of the list.
 
Back
Top