LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Phil
 
Posts: n/a
Default Update fails. Source not found.

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
** Links don't update UNLESS source file is open Jack Links and Linking in Excel 0 July 14th 05 05:55 PM
Data Source Name Not Found Justin Tyme Excel Worksheet Functions 0 June 16th 05 11:45 PM
Automatically update from source when file opens P Flater Excel Discussion (Misc queries) 1 March 25th 05 09:41 PM
Pivot Table Auto Update Data Source? Ket Excel Worksheet Functions 1 February 18th 05 11:14 PM
2003 update link when Source open tim Excel Worksheet Functions 3 January 17th 05 06:25 AM


All times are GMT +1. The time now is 10:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"