File Not Found

[David Page]

I have a spreadsheet that is linked to over 100 other
spreadsheets. Currently, a number of the linked
spreadsheets are not saved on my computer. Every time I
open the main spreadsheet, I get a hundred popups that
say "cannot find file xxx.xls". Is there a way to open
up the main file and avoid all these popups.

 

[nathan]

in the workbook_open put in on error resume next

i think that will work.

 

[Dave Peterson]

When you're prompted to update links, what happens if you answer No?

If you're not asked, try changing:
tools|options|Edit tab|and check "ask to update automatic links"