unable to access file when updating links
Posted by Jennifer on February 27, 2001 12:01 PM
I have a summary report that is linked to many Excel files and every once in awhile, when I have it update the links, Excel gives me a message box that says:
"Unable to Access filename.xls"
Where filename is obviously the name of the file causing the problem. Each time I've get this error, the file IS where it belongs and the link IS to that location, so I guess my questions are 1) does anyone have ideas as to what is causing this (occurrences have been random -- no pattern) and 2) is this a quirk in Excel?
Any help would be greatly appreciated. Thanks!