I am using Excel 2007 and data is updated from other linked XL files.
Even though I have checked "Refresh data when opening the file", it refreshes only Pivot Table data (which is on a seperate tab) but other simple data on different tabs is not updating. When I check the link status in the Edit Links it says "Error: Source not found".
But if I open and close the source file the data refreshes itself without even touching any button.
Even though I have checked "Refresh data when opening the file", it refreshes only Pivot Table data (which is on a seperate tab) but other simple data on different tabs is not updating. When I check the link status in the Edit Links it says "Error: Source not found".
But if I open and close the source file the data refreshes itself without even touching any button.