Link to table
 

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

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