ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Linked files error (https://www.excelbanter.com/excel-discussion-misc-queries/62435-linked-files-error.html)

Sox

Linked files error
 
Hello there
I'm using Excel2003 and have a consolidation file which is linked to data in
20 other files. When opening consolidation I get the enquiry do you want to
update and click Update. I get a message saying that all links could not be
updated and select Edit Links. The list of 20 files which then appears all
have OK as their status. What am I missing here?
Kind regards
Sox



Dave Peterson

Linked files error
 
When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

But I'm not sure that this works on a Mac. But it won't take long for you to
find out.

Sox wrote:

Hello there
I'm using Excel2003 and have a consolidation file which is linked to data in
20 other files. When opening consolidation I get the enquiry do you want to
update and click Update. I get a message saying that all links could not be
updated and select Edit Links. The list of 20 files which then appears all
have OK as their status. What am I missing here?
Kind regards
Sox


--

Dave Peterson


All times are GMT +1. The time now is 06:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com