3D reference does not update

[svjensen]

I use 3D references to sum up data from a number of sheets.
The quite basic formula is along the lines of:
=SUM('Data ->:<- Data'!A1)

with 'Data ->' and '<- Data' being the two delimiter sheets.

The formula works fine, except that it does not update automatically.
If I change one of my data sheets, I have to move it outside the delimiter sheets, and then move it back in. And then the sum updates.

Can I changes this is some way? Is there a setting I need to lok at, or is it due to file size (the file in question is approx. 4,3 MB but I have experienced the problem in other files as well).

I have Excel 2003 installed.

Thanks
Soren

 

[Sandeep Warrier]

Hi

I'm not sure if this will help, but check whether your calculation is set to automatic or manual via Tools|Options|Calculation.

<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[svjensen]

If only it was that easy. It was the first thing I checked

/Soren