calculation mode

  1. R

    Calculation Modes in Excel

    I am having a terrible time understanding Excel's calculation modes and when exactly the message *CALCULATE* appears on the bottom left of the status bar. Let me boil down this down to one use-case. Say you have your spreadsheet set to Manual mode. Further assume you have a subroutine that...
  2. K

    Stop Pivottable Changes From Starting Lengthy Workbook Calculations

    Disclaimer: I have a workbook with protected health information in it (reason why workbook is not attached). Also, I have little experience with workbook and worksheet events. Problem: I have a customer complaining that every time they manipulate a pivottable in the workbook, that the...
  3. L

    Calculation set to manual at beginning of code yet UDF tries to recalculate during code...

    I have a workbook where there is a formula that searches for "Grand Total", as would appear at the end of a range when you've applied a subtotal, and then it takes a number from one column and subtracts numbers from the same row in several other columns, with the hope being that in the end the...
  4. G

    The screen gets crazy and doesn't refresh properly and the calculation method turns manual

    Hi all I am in a big (at least for me) project for a NGO upgrading a tool to forecast. To make everything simpler I basically collate data from 600 tables in different sheets as I explained in this post...
  5. B

    Excel high CPU usage and increasing memory leads to crash

    I have a workbook with a lot of userforms, modules, OLE objects. 6.4 Mb file size. I have successfully used the same template over and over. Now i have one template that shows calculate in the status bar every time a cell is selected. Nothing is even changed. When i update a cell value, cpu...
  6. N

    UDF to run application.CalculateFullRebuild

    I am trying to use a UDF (loaded from an add-in) to force the active workbook to execute a application.CalculateFullRebuild. I am aware that the user can simply do a CTRL+ALT+SHIFT+F9. And I am also aware that I can run a sub with one line with application.CalculateFullRebuild or like so: Sub...
  7. M

    No Book1.xlsx default?

    First, I am running Excel 2007 w/WinXP Pro I want Excel to always open in Manual Calculation mode. To accomplish this, I created a 'dummy' workbook, set the calculation mode to manual (and unchecked calculate before save), and saved the workbook in the XLSTART folder. I also added some VBA to...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top