Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
consolidation calculation
Hi, I have a question about consolidation function in Excel. When I change
the figure in single sheet, how can I make it automatically re-calculate in consolidation sheet? As now, I have to go to Data - Consolidation - OK, is there any way to have them automatically update figure in consolidation sheet after I change data in single sheet?? Thanks a lot Hank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open CSV causes calculation in manual calc mode | Excel Discussion (Misc queries) | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |