Linked Workbook

[anthonyenglish]

I have a problem with Excel which is driving me nuts. We have a workbook which links to another - quite a lot of links to another but I didn't write this!

When you try to update the links Excel just populates the cells with #VALUE!. If you open the spreadsheet it links to, the values resolve themselves. On closing, they drop back to #VALUE!

Is this a resource issue. The PC it is running on is underspec - P4, 2.8 with 256Mb Ram, running XP Pro and Office 2003. A small chunk of the 256 is used for video also!!

The paths are right in the cells with the links.

 

[Richard Schollar]

Hi Anthony

I have observed this myself here at work, and as you say opening the target workbook restores the values. This hasn't caused me any issues because ordinarily we have calculation set to Manual (hence the values aren't lost when the workbook is closed - whilst F9 is not pressed of course).

Can you provide an example of the actual formulas you are using and indicate what the target reference contains (eg Pivot Table, constant cell value, formula etc).
Thanks

Best regards

Richard

 

[anthonyenglish]

Hi Richard

I have just sussed out a workaround. The 'developer' had linked it to a saved spreadsheet on the network and the code was opening another with the same name from a different place. So the one it was linked to was staying closed and the #value errors were creeping in.