C
Cam
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
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