Excel Not Updating
 

Please can anyone help?

We have a workbook containing many worksheets which has formulas in it
picking up from cells within the workbook and other external workbooks but
the formulas are not updating. We have checked and the calculation is not
set to manual (we have tried setting to manual and recalculating by pressing
F9 but it's still not updating). The only way the cell updats is by clicking
in the formula bar but as there are 000's of cells to do this to I was
wondering if anyone had any ideas as to why it's not calculating?

Any help would be much appreciated!

Many thanks.

Rachel

Try CNTRL-ALT-F9
--
Gary''s Student


"Pricklyflower" wrote:

Please can anyone help?

We have a workbook containing many worksheets which has formulas in it
picking up from cells within the workbook and other external workbooks but
the formulas are not updating. We have checked and the calculation is not
set to manual (we have tried setting to manual and recalculating by pressing
F9 but it's still not updating). The only way the cell updats is by clicking
in the formula bar but as there are 000's of cells to do this to I was
wondering if anyone had any ideas as to why it's not calculating?

Any help would be much appreciated!

Many thanks.

Rachel

Hi

ToolsOptionsCalculation and select Automatic

Regards

Roger Govier



Pricklyflower wrote:

Please can anyone help?

We have a workbook containing many worksheets which has formulas in it
picking up from cells within the workbook and other external workbooks but
the formulas are not updating. We have checked and the calculation is not
set to manual (we have tried setting to manual and recalculating by pressing
F9 but it's still not updating). The only way the cell updats is by clicking
in the formula bar but as there are 000's of cells to do this to I was
wondering if anyone had any ideas as to why it's not calculating?

Any help would be much appreciated!

Many thanks.

Rachel

Try this diagnostic:

copy one whole sheet into a new file

does it calculate there?
if so look for VBA code behind the original file. (calculation_Event)

move your file to a new pc does it calculate there?
If so then the Excel application settings of teh first PC need to be reviewed.

"Pricklyflower" wrote:

Please can anyone help?

We have a workbook containing many worksheets which has formulas in it
picking up from cells within the workbook and other external workbooks but
the formulas are not updating. We have checked and the calculation is not
set to manual (we have tried setting to manual and recalculating by pressing
F9 but it's still not updating). The only way the cell updats is by clicking
in the formula bar but as there are 000's of cells to do this to I was
wondering if anyone had any ideas as to why it's not calculating?

Any help would be much appreciated!

Many thanks.

Rachel