Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have six spreadsheets. Each links to 6 different data spreadsheets. I
just moved all of these into a couple different folders for easier maintenance. Now I want to update the links in the main spreadsheets. I can open any of these 42 spreadsheets no problem. When I try to update the links, I get "unable to read file." Status for the link becomes "error:source not found" The source IS there. I browse to it. The source is perfectly fine, not corrupt, full rights, all that jazz. IF I open the data spreadsheets then update the links, all works. Any idea why Bill is doing this to me? Phil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
** Links don't update UNLESS source file is open | Links and Linking in Excel | |||
Data Source Name Not Found | Excel Worksheet Functions | |||
Automatically update from source when file opens | Excel Discussion (Misc queries) | |||
Pivot Table Auto Update Data Source? | Excel Worksheet Functions | |||
2003 update link when Source open | Excel Worksheet Functions |