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
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