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

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

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