I have a workbook that I have been using for months. It contains 5 worksheets with about 200 formulas each sheet. There's also a macro that imports and formats data to feed the worksheet summaries. All in all, it's about 6 MB in size. Admittedly, the worksheet formulas summarize a large amount of data, so recalculating requires about 45 seconds each time the user selects a new geography.
So I wanted to create a new method of generating summaries whereby I build an intermediary sheet to hold all of the summary values and simplify the individual worksheet's formulas to be index/match formulas pointing at the intermediate sheet. The intermediate sheet could be calculated once for all geographies and then remove the formulas before the report is distributed using the macro.
This works well, shortening the update time down to about 3-4 seconds.
The problem is that now when I try to modify anything and then save the workbook I get a message saying "Workbook not saved". Nothing more--Just not saved. Even if I do a File>Save As, I get the same message.
What causes this and what can I do to work around it?
So I wanted to create a new method of generating summaries whereby I build an intermediary sheet to hold all of the summary values and simplify the individual worksheet's formulas to be index/match formulas pointing at the intermediate sheet. The intermediate sheet could be calculated once for all geographies and then remove the formulas before the report is distributed using the macro.
This works well, shortening the update time down to about 3-4 seconds.
The problem is that now when I try to modify anything and then save the workbook I get a message saying "Workbook not saved". Nothing more--Just not saved. Even if I do a File>Save As, I get the same message.
What causes this and what can I do to work around it?
