I have a workbook on manual calc so I can finish some minor changes to
a model that was at 100MB but I was able to bring down to 60MB. With
the few changes I made it should be around 40MB but it isn't saving.
I've shut down the computer a few times and tried saving it with only a
couple minor changes but everything I try gets 'non-responsive' for at
least 20+ minutes. This model only has 2 sheets and the data tab has
28,000 rows with 78 columns. The summary tab is made up of 'SUMIF'
statements and has 3 small tables. Has anyone run across a way to
overcome this situation?