I'm running Excel 2002 on Windows 2000 V5.0.
I have a spreadsheet in which a user loads data into an input area. The spreadsheet has two buttons that execute VB macros. The first button is used to analyze the data and copies formulas onto several existing tabs. This first button typically takes about 3 minutes to execute. The second button simply deletes the formulas copied by the first button (deleting formulas in the reverse order that they were created) and restores the spreadsheet to the state it was in before the first button was pushed. This second button takes over 17 minutes to complete.
I'm trying to see if there is a way to get Excel to do the formula deletes quickly. (I'm assuming that Excel is trying to maintain cell recalculation flags or something and that is making the delete time long. If so, can this function be turned off? I turned the calculation mode to manual, but that doesn't seem to speed things up.)
I have a spreadsheet in which a user loads data into an input area. The spreadsheet has two buttons that execute VB macros. The first button is used to analyze the data and copies formulas onto several existing tabs. This first button typically takes about 3 minutes to execute. The second button simply deletes the formulas copied by the first button (deleting formulas in the reverse order that they were created) and restores the spreadsheet to the state it was in before the first button was pushed. This second button takes over 17 minutes to complete.
I'm trying to see if there is a way to get Excel to do the formula deletes quickly. (I'm assuming that Excel is trying to maintain cell recalculation flags or something and that is making the delete time long. If so, can this function be turned off? I turned the calculation mode to manual, but that doesn't seem to speed things up.)