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