I have a spreadsheet with links to other excel files. (All excel 2003).  When
I open the spreadsheet, the cells all show #VALUE! until I open the other
spreadsheets that the links refer to.  Is there any to fix this so that the
updates work without opening the other spreadsheets.

I have posted this in excel.misc but this seems to be a better fit.
Apologies for the duplicate Post
I have an Excel workbook (Call it A) that extracts version informaton
from a series of templates.

I want to move a spreadsheet, call it Sheet A.
Is there a way to determine what other sheets link to Sheet A?
Thanks,

I have a master spreadsheet that has several sheets.  Each sheet is reading
data from a separate external spreadsheet C:\Data using the below formula.
IF($AH5="","",IF('C:\Data\[Generic.xls]sheetTFF'!$A5="",A4,'C:\Data\[Generic.
xls]sheetTFF'!A5))

I have a spreadsheet which contains over 1,000 hyperlinks to a website.
Many don't work because they are missing two semi-colons.
Is there a quick way to check which ones have the missing semi-colons and to
insert them.  There are two places in the hyperlink where they should

Well, I have a problem.
My open workbook is Named "One.xls"
My closed workbook is Named "ClosedBook.xls"
      This "ClosedBook" is located as indicated in my code:

I have a table (4x4). It looks something like
A1 = x   B1 = 40   C1 = 0.5
A2 = ""   B2 = 50   C2 = 0.7
A3 = ""   B3 = 60   C3 = 0.9