 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / April 2008HELP! optimize calculating values
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 You can change the default from automatic to manual calculation. Tools -> Options -> Calculation -> Manual You they use F9 to recalculate. The reason that you have this problem is that you have surpassed the smart calc limit in XL. Check out this link for more info... http://www.decisionmodels.com/calcsecrets.htm  SignatureHTH... Jim Thomlinson > Hello, > [quoted text clipped - 6 lines] > then update the formulas after all the changes, not update every once change? > Thanks Jim I was wondering why the option went back to automatic update after I save the document, exit and reopen the file after I changed to Manual updating? Thanks > You can change the default from automatic to manual calculation. > Tools -> Options -> Calculation -> Manual [quoted text clipped - 14 lines] > > then update the formulas after all the changes, not update every once change? > > Thanks You can change from Automatic to Manual recalculation by clicking on Tools | Options | Calculation tab. Then you can make your changes and press F9 when you want a full recalculation. The file is usually recalculated immediately before a Save operation, but this is another option you can change on that tab. Note that any other files that you open while in that same session with Excel will also inherit the Manual calculation mode. Hope this helps. Pete > Hello, > [quoted text clipped - 6 lines] > then update the formulas after all the changes, not update every once change? > Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.