Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I have a complex Excel file that have several sheets with calculated formula and conditional formatting, etc... The raw data came from importing data from an Access file, then several columns with calculated data. Everytime I change a value in any rows, it takes forever to recalculate the values in the formulas, even just changing one value in the row. Is there an option in Excel that allow me to change all the necessary data, then update the formulas after all the changes, not update every once change? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I optimize system settings to support Excel? | Setting up and Configuration of Excel | |||
How to use Solver to optimize when the formular contains Round() f | Excel Discussion (Misc queries) | |||
Optimize simple macro | Excel Worksheet Functions | |||
Optimize SumProduct | Excel Discussion (Misc queries) | |||
Optimize SumProduct | Excel Worksheet Functions |