ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Excel Macro runs fine, but freezes if I try to do ANYTHING else whileit's running (https://www.excelbanter.com/setting-up-configuration-excel/270659-excel-macro-runs-fine-but-freezes-if-i-try-do-anything-else-whileits-running.html)

Rruffpaw

Excel Macro runs fine, but freezes if I try to do ANYTHING else whileit's running
 
I have a very large Excel spreadsheet (13 MB) with several macros. One
of them runs a loop with multiple commands.

The macro runs fine, as long as I sit back and just watch it run. If I
click on another window however, it invariably freezes and I have to
terminate Excel.

Any ideas on how I can remedy this?

I'm running Excel 2003 on Windows XP, but have noticed the same
problem with the same spreadsheet on a machine running Excel 2007,
also on Windows XP.

Thanks

-Sharat


All times are GMT +1. The time now is 01:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com