Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2007 Link to other files

Status
Not open for further replies.

Wajid55

Programmer
Apr 6, 2006
48
CA
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top