| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel not responding. Only works if I run split macro in 2.
Excel file is 46mb. Has 2 macros. Ist macro selects company in use and
populates data tables based on company in use. The second macro is an automated goal seek calculation. If run ist macro and save and close file and shut down machine, then restart and run the 2nd macro then the file calculates correctly. If try to run Ist and 2nd macros sequentially then Excel stops responding during the 2nd macro. Have upped RAM to 3 GB and increased processor to 2.8 MHZ, but makes no difference. How do I stop excel hanging / not responding |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel not responding. Only works if I run split macro in 2.
Nick wrote:
Excel file is 46mb. Has 2 macros. Ist macro selects company in use and populates data tables based on company in use. The second macro is an automated goal seek calculation. If run ist macro and save and close file and shut down machine, then restart and run the 2nd macro then the file calculates correctly. If try to run Ist and 2nd macros sequentially then Excel stops responding during the 2nd macro. Have upped RAM to 3 GB and increased processor to 2.8 MHZ, but makes no difference. How do I stop excel hanging / not responding have you tried adding an auto save in the macro. so macro 1 runs, then saves before starting macro 2? Anthony |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel not responding. Only works if I run split macro in 2.
Hi Anthony
I added "activeworkbook.save" at the end of the Ist macro, then ran the 2nd macro. Unfortunately, excel is still hanging ("not responding"). "Anthony Taylor" wrote: Nick wrote: Excel file is 46mb. Has 2 macros. Ist macro selects company in use and populates data tables based on company in use. The second macro is an automated goal seek calculation. If run ist macro and save and close file and shut down machine, then restart and run the 2nd macro then the file calculates correctly. If try to run Ist and 2nd macros sequentially then Excel stops responding during the 2nd macro. Have upped RAM to 3 GB and increased processor to 2.8 MHZ, but makes no difference. How do I stop excel hanging / not responding have you tried adding an auto save in the macro. so macro 1 runs, then saves before starting macro 2? Anthony |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro is not responding | Excel Worksheet Functions | |||
| Macro do works in excel... | Excel Worksheet Functions | |||
| Excel macro works only for administrator | Excel Discussion (Misc queries) | |||
| Macro hangs my excel (not responding) | Excel Programming | |||
| Macro no longer works now that in Excel XP | Excel Programming | |||
Hybrid Mode
