Iterative Calculations

So I have recently made some quite useful spreadsheets with just using basic formulas and seem to have hit a wall with a few things.

I can’t seem to permanently enable iterative calculations. I would like it to be linked to a document but would be ok with having to set it permanently on computers.

If this can not be done I may be forced to use VBA unless anyone has other suggestions.

Currently I have one spreadsheet which records peoples performance of a task by their initials. I have a second sheet which counts the total instances of the initials and records it. I have it set up to “save” the values at the end of every month so total performance is recorded per month. Unfortunately to get the functions to stay a value after a certain date I have been forced to have the cell refer to itself or a loop in cells causing a need for iterative calculations to be enabled.

Any help would be greatly appreciated.

Leave a Reply

Your email address will not be published. Required fields are marked *