automatic calcutations

  1. S

    Automatically Updating Formulas

    I am trying to insert a string of formulas on a separate sheet from my data, ie standard deviation, median, mode, etc. I am trying to get the sheet of formulas (sheet 2) to update automatically given the data that is selected on sheet 1. Sheet 1 is filtered by categories allowing the user to...
  2. R

    Automatically Place Text, which is user-editable

    Hello, This might be a simple, straight forward issue. I am trying to automatically place text from one cell into another cell, and have that cell, editable. Let me Explain. If i have "Hello" in Cell A1, I would like to have a formula in say, cell A2, that automatically places the text "Hello"...
  3. S

    How to omit cells from automatic calculation?

    I would like to omit some cells (a single column, as it happens) from automatic calculation, but I don't want to switch the entire worksheet/workbook to manual calculation ("F9"). The reason for this is that the column in question contains some fuzzy matching formulas which can take a long time...
  4. A

    Workbook Calculations

    Is there a way using VBA Workbook_Open() to set workbook calculations to automatic if the user does not have automatic calculations turned on?

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