Problem with links and #REF

martin_malin

New Member
Joined
Mar 30, 2005
Messages
44
We just migrated from Excel 2000/Windows2000 to Excel2003/WinXP. We have a consolidation model that opens about 50 different files from different users across the company. Before, everything went very well. Since the migration, some #REFS come up in the files where there is linked cells to the divisions folders (which we don't have access to). What is weird is that one cell would be fine and the other cell would be showing #REF while the formula are exactly the same except for the reference that are respectively referring to C40 and D40 from another file for example.

If we open the template on an manual calculation mode, no problem. When we hit F9, #REF shows up. We have been running this model for the last 4 years and never experienced any problem. Could this be due to the migration?

Any help? We don't want to chase #REF and paste data into value everytime it happens, there is too many !

HELP!
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Watch MrExcel Video

Forum statistics

Threads
1,118,032
Messages
5,569,764
Members
412,291
Latest member
marypolitan
Top