Cell formula not updating, auto calc on, over 100 sheets
 

I am having trouble with cell formula's that reference from one sheet to
another not updating. i.e ='Sheet1'A1. The cells update fine when the number
of sheets are less than about 100, but when the number of sheets are above
this the cells will only update buy double clicking the cell and clicking
enter.

Excel 2003, Tools|Option|Calcutations is set to Automatic, sheets are
created by a macro

Cell formula not updating, auto calc on, over 100 sheets
 

Found a way around this but not really a fix. Saving, closing and opening the
file solves this problem. Anyone else come across this kind of behaviour? I'm
not 100% sure it's because the number of sheets are higher than 100, the
sheets are created by a large macro, maybe this is causing the problem?

"mcphc" wrote:

I am having trouble with cell formula's that reference from one sheet to
another not updating. i.e ='Sheet1'A1. The cells update fine when the number
of sheets are less than about 100, but when the number of sheets are above
this the cells will only update buy double clicking the cell and clicking
enter.

Excel 2003, Tools|Option|Calcutations is set to Automatic, sheets are
created by a macro