Excel memory size increases, Excel crashes, Not enough resources

[satishpandeycs]

Hi All,


I am using an excel macro file size - 3 mb approx which is link with SQL server. We have made data connections queries and refreshes whenever it required. We usually works on this file for 1 - 2 hours daily and it crashes, sometimes within 30 mins and got an error like 'Not enough resources' and excel crashes. Although we came accross the issue like excel memory increasing just on click on ribbon (without a single line of code execution) or just executing application.screenupdating,application.enablecancelkey, application.calculation and application.enableevents vba codes.We tried all the possible solution suggested on msdn websites or other websites but could n't resolve these issue. Can anyone help me or have exact solution unlike the other websites solution?

 

[Sektor]

Perhaps, you try to import lots of data from SQL Server - and Excel lacks memory.