It sounds to me like your formulas aren't pointing to the correct
folders/filenames/sheetnames.
Maybe you could open the workbook with all the links, but answer No to updating
links.
Then Edit|links to see where they point to.
(and open windows explorer to verify that they exist where they should.)
MEG wrote:
I have a spreadsheet that links to several spreadsheets-- 1 for each month of
the year. These monthly speadsheets are not open when opening the single
speadsheet.
When the spreadsheet opens it asks to update the LINKS and I respond YES.
Months Jan to Oct work fine, but when it tries to update the Nov and Dec
links, it acts like it can't find the spreadsheets. I have to navigate to
the network drive and reselect it. After doing some work in the spreadsheet,
I save it. Yet again when it is opened, it still can't find these same
spreadsheets.
What tools can I use to debug the problem? Is there a way to see all the
links in a spreadsheet? Or what other ideas does anyone have?
THANKS,
MEG
--
Dave Peterson
|