I have a fairly complex workbook and it got to the point that doing certain things become very slow. I would like to optimize the responsiveness of the workbook. I think I tried as many ways to improve as I know. That including replacing all volatile functions, using dynamic ranges, removing external references, etc. But I don't think I could cover the workbook completely as it's fairly complex and it's done by someone else.
Is there a VBA or macro that can measure the time need to calculate all cells in Excel? I would think a macro that run every non-empty cell in a workbook and return a new sheet that has how much time need to calculate a cell for every cell. That would point out which cell/formula should be improve.
Is there a VBA or macro that can measure the time need to calculate all cells in Excel? I would think a macro that run every non-empty cell in a workbook and return a new sheet that has how much time need to calculate a cell for every cell. That would point out which cell/formula should be improve.
Last edited:
