I use Office 2003.
20 different Excel spreadsheets, to which I will refer as “source files.”
1 Manager’s Summary file, containing links to the source files so that each of the 20 source files feeds information into one of 20 different rows in the summary file.
When I open the summary file I get a screen that says, “This workbook contains links to other data sources."
When I click "Update" I get a second screen that says, “This workbook contains one or more links that cannot be updated."
When I click on "Edit Links" all linked files are listed as “OK.”
The data is actually updated correctly, so the summary file is correctly reading all the source files.
I just want to get rid of the second error message mostly because it is a nuisance, but also because it causes the managers reading the summary to question the accuracy of the summary file.
Anticipating your questions:
The source files contain no named ranges at all.
The source files contain no macros at all.
None of the source files are in HTML.
Your help will be greatly appreciated!