I am having issues with my Excel 2007.
Basically I am trying to link to Pivot Tables in external spreadsheets. Whenever i try this i get a #REF! error.
I have found that the only way to get around this is by clicking the 'Data' Tab -> Click 'Edit Links' button -> Highlighting all the links and Clicking 'Open Source'.
This however is not really much help as i could be linking to 20 - 30 external spreadsheets and cannot open every single one at the same time.
Does anyone know of a way to avoid the #REF error without having to open all the external spreadsheets it references????
Or is opening up all the external spreadsheets the only way??
any help with this would be very much appreciated!