Excel linked workbooks problem

  tessie 12:04 03 Apr 04

Linked monthly workbooks have stopped updating and REF appears in the linked cells. An error message box reading "Excel cannot complete this task with available resourses. Choose less data or close other applications" appears. When this closes help assistant says unable to update values. The only way to get the sheets to update is to open all previous workbooks. I have gone through the help checks and nothing seems to solve the problem Can anyone help me please

  VoG II 12:10 03 Apr 04

How many workbooks involved? Do they have named ranges? Which version of Excel? click here

  VoG II 13:38 03 Apr 04

Via e-mail:

There are 12 workbooks. No ranges and it is XP Office pro version. Thank you for replying


Please stick to this thread - post a response at the bottom of this page. E-mail is for private correspondence between forum members.

click here is the only other MS article that I can find relating to this type of error.

I would suspect that the root cause is simply too many levels of indirection as in my first post's "click here".

The reason for #REF errors is commonly formulas that refer to named ranges that do not exist, so check the formulas carefully.

Some formulas require thye source workbook to be open (e.g. using the INDIRECT function).

Also look for phantom links click here

Failing all of the above, you could try Detect and Repair from the Help menu.

This thread is now locked and can not be replied to.

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch