I have made a macro that takes a worksheet of data and turns it into several summaries of that data. The macro works fine, but if any values are changed after the macro finishes, formulas that reference them will not automatically update, even if they are simple sums. I have to manually select each formula and press enter to update its values. Does anyone know why this might be happening?
One possible reason for this is that some variables early on in the string of equations reference values in another spreadsheet. I know that formulas which reference values in another spreadsheet will not normally update automatically, so maybe cells that reference those cells, or cells that reference cells that reference those cells, etc., from autoupdating.
I am posting this problem in the programming forum because I am almost certain that this is because of a macro, since only macros edit the document itself.
If anyone has encountered this problem before and knows how it might be fixed, please tell me.
Bookmarks