I don't use workspaces, but...

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


charles banks wrote:

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

--

Dave Peterson