PDA

View Full Version : Excel not updating



Ruckley
03-09-2011, 11:16 AM
Hi.

I have a workbook I have been working on for some time that is frequently not updating. The cell references are all correct and the Calculation mode is set to automatic but some cells are displaying incorrect information, despite containing correct references to other areas of the workbook.

Any ideas gratefully received.

R.

joms
03-10-2011, 01:05 AM
can share the workbook? so guys around here can have a clear picture of the problem.

mancubus
03-10-2011, 01:38 AM
hi.

recalculate by hitting CTRL+ALT+F9 (or save the file).

Ruckley
03-10-2011, 03:42 AM
Hi, thanks for the info.
I can't include the workbook as its confidential.
But, I wonder if there's something to do with a size limit. Its about 20 MB.
It updates most of the time OK. But sometimes it just seizes up. Updating manually is not ideal as its for distribution to clients.

Bob Phillips
03-10-2011, 07:09 AM
Why is it 20Mb, why so big.

JWhite
03-10-2011, 08:46 AM
Did you try the ctrl-alt-F9 as Mancubus suggested? That ALWAYS works for me.