Trying to simplify an Excel file that I've inherited from an long-gone employee. No one can get it to work so I'm trying to strip down all of the fancy functions and just leaving functions that are actually performing calculations.
I am having some issues with stability. When I first enter the functions and formulas into the worksheet it seems to work well. The numbers look correct, no errors. But when I click into a cell and click out of it, the correct value then changes to a zero.
Any advice is appreciated.
EDIT - SOLVED! I found the answer as a Google search pointed me to another post in this forum. It was just a matter of enabling iterative calculations.
Bookmarks