Automatic Calculation Problems

M

mjs59

The workbook I have been developing for the past couple of days ha
stopped updating automatically. The options are still set to Automati
update, and even Calculate Now and Calc Sheet don't work.

The only way to refresh formulas appears to be pressing enter an
sorting (so if you need to sort, you have to do it twice).

The workbook is getting fairly large, and with it atleast doubling i
size again, can anybody suggest a solution?

'Zurich Premiership
(http://www.caldecote57.freeserve.co.uk/ZP2004.xls
 
T

TK

Just a stab in the dark, but have you checked for circular
references? That can cause calulations to stop updating.

Otherwise, maybe you are running out of memory. How big do
you mean when you say it is 'fairly large'?
 
M

mjs59

I don't have any circular references.

The file size is now 2.38 mb, and is mostly formulas!

My PC is fairly good 2.6ghz, 512 RAM, but even when the formulas d
automatically update, other things so down for a second or two
Slightly worrying because I was hoping for end users to take the fil
and update themselves, but full functionality first, and then i'll cu
it down!

Edit: Just to add Ctrl+Shft+Alt+F9 will recalculate all, but other F9'
do not. I'm guessing processing power is the problem..
 
D

Dave Peterson

How do you know that it stopped calculating?

If you're believing the statusbar, this may apply for you.

http://support.microsoft.com/?scid=243495
XL: Calculate Message Remains in Status Bar If 65,536 Formula References

If you make a change and don't see a formula reevaluate (when it should), maybe
(just maybe), this will work--force excel to see all the formulas as formulas
again.

select/group all the worksheets
ctrl-A to select all the cells (ctrl-A twice in xl2003)

edit|replace
replace: = (equal sign)
with: = (equal sign)

Maybe it'll wake up excel.

Don't forget to ungroup your worksheets when you're done.
 
M

mjs59

Thanks Dave. The formulas actually weren't updating, they would with F2
and Enter, but not automatically without Alt+Ctrl+Shft+F9. The status
bar is responding, it is just the other combinations didn't seam to
trigger a refresh. Anyway i'll do a few tests and report back on the
Find and Replace.

...Just as an aside there were 39261 formulae, possibly a source of the
problem!
 
Top