recalculation

  1. K

    Detect change in cell value caused by recalculation of changes made elsewhere

    Hi, I would like to run a macro if any cells in a given range change in value. I tried to use Private Sub Worksheet_Change(ByVal Target As Range), however this only seems to return the cells whose values are changed directly (i.e., as input values), rather than by recalculating formulae that...
  2. C

    Sumif worksheet recalc process

    Regarding how SUMIF recalculates...I have a large worksheet with many grouped rows (1600+) and 115k sumif formulas with a pretty crazy dependency tree. Each time an input changes or a group of rows is expanded the worksheet recalculates and it takes quite some time. Assuming a sumif is...
  3. R

    #num! Error as worksheet is not recalcaculating the cell

    I am using Excel 2007 / Windows 7 Home Premium / PC not a MAC I have a tab where I use a pull down to select from a list (there are 80 of them) and based on the resulting position in the database, it pulls data from various locations (using index) to display the info. It works for ALL of...
  4. C

    Automatic Calculation

    I have 2007 and have set up what is likely more convoluted worksheet than necessary however I think I am close to achieving what I was hoping for and have run into a problem. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have a “data” worksheet with a...
  5. M

    How to avoid automatic recalculation after importing data with OpenText?

    Hi, I'm importing data using the Workbooks.OpenText VBA method in Excel 2007. The problem is that for a reason it automatically re-calculates my active workbook even though I've set the calculation option to Manual. Since the re-calculation takes a while, I would like to avoid it at this...
  6. B

    Excel Recalculation Speed

    I want to count the next 12 values within Column C. However, based on the values in column K, there may not be 12 values of the same product code remaining hence the countif formula. This formula has really slowed down the spreadsheet and I'm looking for a simpler/faster formula...
  7. W

    find and Replace method for quick calculation not working

    Hi everyone I'm on Excel 2007 and have a spreadsheet that takes about 35 minutes to recalculate the present worksheet using Shift+F9. I was having success with using find and replace when altering a formula in a column e.g. if the forumla was A2*A3 I'd make it A2*A3&53, copy it down the...

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