iterative

  1. S

    getPressed issue

    Hi, I am trying to set up a checkbox in the ribbon that activates/deactivates iterative calculations. I manage to get this working. However, I don't manage to update the status of the checkbox if "iterative calculation" status is changed in Excel settings. I can have iterative calculations off...
  2. W

    Enable / Disable Iterative Calculations

    Hi, Can anyone help me to build a button which enables/disables iterative calculations? I'm not really sure how to do it and I have googled it all to no avail.
  3. D

    Automating the Creation of Reports

    Hello all, I am looking to make 1000+ reports based on a template. I have other sheets referencing the target city to update the data they report on. I have a macro that saves the current workbook following the naming convention "Target #". In this case "Austin 1". I will then change the...
  4. D

    Combining Do Loops with other Macros statements

    Hello all, I am looking to make 1000+ reports based on a template. I have other sheets referencing the target city to update the data they report on. I have a master macro that calls on three other macros to format accordingly and save as "Location Report- Austin 1". After creating the Austin...
  5. N

    Permanent Iterative Calculation

    I have several spreadsheets that require the 'Enable Iterative Calculation' to be selected in order to work correctly. Our business calcs require circular calculations on almost every sheet. Once I have this option checked, it stays active but only for me. It does not stay checked for my...
  6. A

    VBA iterative calculation

    Hi all, It's my first post here; I have used solutions from this forum and others for various Excel issues over the years but this one I cannot seem to crack or find the answer to! Please help!! My general Excel skills are pretty good, but I have been unable to solve this issue using...
  7. J

    Limiting Data Validation Drop Down Menu Frequency

    Hello. I have a list of people who need to select training dates from a list available. I have created a Data Validation drop down menu for the people based off a list of classes available. I have also created FILTER formulas to sort the attendees into attendance lists. My only issue left...
  8. G

    Iterative COUNTIFS formula

    Hello everybody, I am trying to get an iterative calculation of the number of times certain exact numbers appear in a range. I seem to be hitting a few bumps with the COUNTIF formula. Example: If cells A1:A3 contain the numbers 1, 2 and 3 in any order i want the formula to return 1, so then i...
  9. A

    Iterative Calculation not working

    My real estate development model includes a circular reference but for some reason if a refinance date changes the #num ! error appears. Does this have to do with my iterative calculation not working?
  10. T

    Can you send a file with iterative calculations enabled?

    So here's my problem, I need to send out a file that requires iterative calc's to be enabled in order to work properly, however its going to a large number of people that may or may not have the knowledge base to adjust the settings. Is there a way to "pin" my iteration settings to the file so...
  11. C

    Why does my excel crash due to circular reference warning?

    Hi Mr Excel, I have created a model and there is a row that is impossible to delete. When I try to delete it, the following error message comes up and I have to re-start Excel. 'Circular reference warning One or more formulas contain a circular reference & may not calculate correctly...
  12. C

    Iterative Calculations

    Hi all, I have a set value in cell B1 that will be changed constantly. Cell B7 has a formula written based on the values of cells B3, B4, and B5. The values in cell B3 and B5 do not change, meaning they are constant and will always be 4 and 10, respectively. Is it possible for Excel to...
  13. J

    Can Excel options be made as default or 'sticky'

    I have a question about whether certain Excel options can be set as default, or otherwise be made 'sticky' so that I don't have to set them again and again when opening the same spreadsheet. I believe the question is generic, but in this case I am using Excel 2007 SP3 MSO and running on Win7...
  14. W

    Recursive Calculation Issue

    Hello, After so many years of saying that there was no need to use VBA, I think I've reached my breaking point. Any help will be greatly appreciated! :-) Being a beginning at VBA, can someone please assist? I am trying to calculate the sum of a string of products under certain limitations...
  15. K

    Tough one--need help modeling an iterative job posting process.

    I'm trying to model a somewhat complicated HR process where employees are allowed to voluntarily post to more preferred shifts and depts. I'm starting to thinking excel may not be the most effecient tool, but I can't back down from the challenge! Here's the situations--When there's a need to...
  16. T

    Finding the last instance of a word and working relative to that cell

    Hi, I think this is a very basic question but i'm an utter noob at vba. I've just started recording some macros to have a look at basic syntax and functions. I have data brought in from another system which is formatted for printing. So after every x amount of lines it breaks onto another page...

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