Home > IT Answers > Microsoft Windows > Linked Workbooks return #VALUE error until linked workbooks are opened
Blubudda
5 pts.
 Linked Workbooks return #VALUE error until linked workbooks are opened
Excel 2003, Excel 2007, Microsoft Excel
I used to save linked workbooks onto a remote server. One could be opened and it would display the last values it had. Now, the linked formulas show #VALUE error until the linked sources are opened. I'd really like to be able to open just one workbook at a time. Is there some setting in Excel 2007 to change this behavior?

Software/Hardware used:
ASKED: September 26, 2008  3:39 PM
UPDATED: February 7, 2010  7:09 PM
RELATED QUESTIONS
Answer Wiki:
I cannot duplicate your problem. Excel 2007 loads old values by default and prompts for link update if linked workbook not loaded (this behaviour can be changed to automatic link updateing (NOT RECOMMENDED) through the Trust Centre section of Office Button --> Excel Options. The behaviour of Excel 2007 seems to be exactly what you require. Maybe I have missed somethoing in the details of your problem.
Last Wiki Answer Submitted:  September 29, 2008  11:24 pm  by  BobBeechey   750 pts.
All Answer Wiki Contributors:  BobBeechey   750 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Please let us know if the linked work book is store on the same system or the network drive. Does it happen with one excel workbook or all MS Excel work book.

Try the steps below
move the sheet from linked workbook to the same workbook from where it is referencing. Refresh links. Move the sheet back to link workbook and save both workbooks.

I know this sound little tedious job

Regards,
Sarfaraz Ahmed
MS Excel help

Findsarfaraz
 1,395 pts.
 

Maybe you have one worbook in Excel 2007 and the other one in Excel 2003. Try to have bouth excel file in 2007 version.

Enick
 10 pts.