View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
charles banks
 
Posts: n/a
Default Help with Broken Links


Links help. I am having some difficulties and have not been able to find
any solutions.

Background Information:
A series of excel files (A) that I have created from a download from
our financial system.
A series of files (B) that refer to these downloaded files to create
YTD and MTD calculations.
The calculations are dependant from a master navigation worksheet (C)
where users select the appropriate time frame.

If I open files (B) individually they work perfectly. The problem
occurs when I attempt to open all the (B) files through an .xlw or
workspace extension containing all of (B). When I attempt to do this I
get an "edit links" prompt from one of the files. This normally this
occurs with some broken links. I check through "File -- Edit --
Links, Update Values" and all the files have an "OK" status.

I have tried "change source" to re-establish the links but this is not
fixing the issues.

Any help that could be provided would be greatly appreciated.


--
charles banks
------------------------------------------------------------------------
charles banks's Profile: http://www.excelforum.com/member.php...o&userid=30517
View this thread: http://www.excelforum.com/showthread...hreadid=501701