Update Links Error

R

Ryan

I have a spreadsheet that links to over 20 other files.
Everytime I open the spreadsheet it gives me an error
stating that says, "This workbook contains one or more
links that cannot be updated." I have searched and
searched through every single tab for REF# and REF#!
errors but have found NOTHING! It is driving me nuts!!
Can anyone help me with advice or suggestions as to what
is causing this error? Thanks! - Ryan
 
R

Ryan

BTW, I have checked and double-checked the links in the
EDIT/LINKS menu...as well as open up all the files and
made sure everything looks good (note: all the external
files are exactly the same so the row/column references
are always the same).
 
R

Ryan

Thanks, I downloaded and installed it...I have to go
through each sheet and unhide rows...I bet that is why I
couldn't find the error...because they are hidden!!

- Ryan
 
S

Sid

I just started using Excel 2003, and I also get the same
message from time to time. I can't figure it out either.
I'm using the same workbooks and macros that I've used for
over a year under Excel 2002, and I NEVER got these
link-update messages. I hope some Microsoft person is
reading this and will post an explanation. Sid
 
Top