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...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top