I have two spreadsheets. This one (PTRates.xls) is linked to this one (NewRates.xls). As long as the source is designated as a drive letter, when I make a change in NewRates.xls, it IMMEDIATELY shows up in PTRates.xls (well, as soon as I leave the cell).
So far, so good.
The problem is that there are multiple users viewing PTRates.xls and they have different drive letter mappings. I solved that by putting in the full unc path as the link source (\\server1\vol1\user\home\NewRates.xls).
Okay - here's my question: Now when changes are made in NewRates.xls they don't show in PTRates.xls until NewRates is SAVED (Not just leaving the cell) AND not until PTRates.xls is reopened.
Calculation is set to automatic. Pressing F9(Calc Now) does NOT refresh the data.
Anyone have any ideas why the instantaneous update quit and how I can get it back - other than the drive letter of course - since the user's drives are mapped differently.
P.S. We are using Excel 2003