Linked Workbooks return #VALUE error until linked workbooks are opened

15 pts.
Tags:
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Findsarfaraz
    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
    1,395 pointsBadges:
    report
  • Enick
    Maybe you have one worbook in Excel 2007 and the other one in Excel 2003. Try to have bouth excel file in 2007 version.
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following