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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
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 |