iterative

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

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.

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

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

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

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

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

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

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?

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

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

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

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

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

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

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