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