Excel does not calculate

[jonh]

Hi,

I have quite a large spreadsheet which is used for stock calculations at the end of each month. Each location carries the same stock items, so the structure & layout of each sheet is consistent throughout the workbook. The first sheet is the 'Totals' page which calculates the grand total using sum(sheet1...sheet99), however, recently, when I add a new location (always in the middle of current locations), the Total Page does not automatically recalculate although autocalc is switch on.

However, if I select a cell with the 'Totals' page, edit and return on the formula, it then gives the correct answer.

Just wondering if anyone has come across this problem? I didn't think there was a maximun to the number of sheets you could add to a workbook.

Thanks for you help.

Jon

 

[Andrew Poulsom]

Maybe try Ctrl+Alt+F9.

 

[jonh]

Thanks for the response. Tried this previously but it doesn't work. My only method of forcing Excel to Calculate is to Edit the formula and return on it. Even closing Excel does not work as in theory, this should force Excel to Recalculate.

Regards,
Jon

 

[Andrew Poulsom]

I've never known that not to work, but another suggestion is to choose Edit|Replace = with =.

 

[jonh]

Thanks, I'll try that.

Regards,