| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round amount to nearest $10 after other formula calc. in same cell | Excel Worksheet Functions | |||
| Auto Updating Formula | Excel Discussion (Misc queries) | |||
| Cell showing the time auto updating | Excel Discussion (Misc queries) | |||
| Updating one cell with a formula | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
