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