calculation mode

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

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

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

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

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

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

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