autocalculate

  1. M

    Macro for autocalculate based on text in cell

    Hi All, I have an excel file with many tabs. I need a macro to AutoCalculate only few sheets based on text in cell. Need a macro to turn On/Off autocalculate based on text in cell. If a text in Cell is "ABC" then i need sheet1, sheet5, sheet6 and sheet9 need to Calculate and rest all sheets...
  2. R

    Setting for auto-populating formulas 'invisibly'?

    This is my first time posting a question, because I've always been able to find pre-existing answers in the past - thank you! My issue is hard to describe but I'm sure the solution is maddeningly simple: I have a spreadsheet with data in Column A, and a formula that references it in Column B...
  3. A

    Turn off Vlookup auto calculate on worksheet

    Hi all I have a worksheet that uses a macro to perform a vlookup which basically returns stock values on a daily basis. I need the worksheet to record stock levels on a daily basis so that if a product is out of stock for more than 1 week then another formula will warn me a particular product...
  4. S

    Autocalculate and forced calc do not work in Excel 2003

    I am a systems analyst and one of my users has a random problem with spreadsheets where she enters a formula and it does not calculate. She is using Excel 2003. Here are the things I have already checked out: Autocalculate IS turned on The numbers ARE really numbers and not text Editing...

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
Back
Top