Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display form from an VB application in Excel | Excel Discussion (Misc queries) | |||
Excel updating from XML file - file path specific? | Excel Discussion (Misc queries) | |||
Updating excel sheet with selected data from another sheet in the same file | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
updating invoice number on excel spreadsheet | Excel Worksheet Functions |