Get instant live expert help on I need help with excel iterative calculation

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have circular references (intentionally) and the iterative calculation is not working correctly.
Solved by T. L. in 24 mins
Circular ref will not allow me to open and can't select enable iterative calculation . It's greyed out
Solved by M. E. in 14 mins
i've entered a formula, but it’s not working. Instead,i’ve got this message about a “circular reference.” , and you i have a feature called iterative calculation turned off
Solved by S. A. in 14 mins
actual - expected calculation in excel steps?
Solved by X. J. in 21 mins
hi, i am trying to import data from one excel sheet to another based on the date. One of the files is dynamic and changes/overwritten daily, therefore the date changes and the values are replaced. The problem i am having is keeping the data in the target spreadsheet once the date changes. Everything i try gives me a circular reference. I am opening the files and updating using a batch file so enabling the iterative calculation in the options wont cure it. Below is a sample of the calculation i am using in one once of the cells: =IF(A19='daily exports30.csv'!$C$5,'daily exports30.csv'!$B$49,AY19). AY19 looks at the cell with the calculation in to ensure its saved when the date changes. I have no experience with macros or VB so im struggling. can you help????
Solved by V. D. in 21 mins