Forum Discussion
redzone7827
Oct 16, 2020Copper Contributor
Excel formula not updating correctly/automatically
Hello! I am having an issue with the attached spreadsheet that the formulas in the tax and insurance schedules are not updating correctly unless I click in to the formula in the cell and hit enter. ...
SergeiBaklan
Oct 16, 2020Diamond Contributor
You have circular references in formulas
with them result is always unpredictable. As first formulas shall be cleaned from such references, and only after that check if result correct or not.
- redzone7827Oct 16, 2020Copper ContributorAh..ok, I didn't realize it showed that there, thank you! I'll look at trying to remove the circular reference and post again if I have any issues. Thank you!