Increase memory

[behedwin]

Got a quite large excel sheet that is used for lots of ppl.

Sometimes i get reports that ppl get "out of memory" warning and then it closes down.

Is there a way for one sheet for all users of it (no matter what computer they are on)
to have more memory diverted to excel?

 

[gallen]

I don't think that is your issue. I'm guessing there is a bug in a macro that is cauing an infinite loop which would cause that error message

 

[behedwin]

That might be it.
Will look for one... think i have an idea of where the loop could be.

 

[dsheard2015]

I'm having sort of the same issue, but instead of getting a message saying that there's not enough memory I can't save the file due to not enough memory. Also, I have noticed that when this file is open my excel is using large amounts of memory which causes it to lock up at times.

I too have a very large workbook, around 560 worksheets, and lots of vba throughout. How do I go about searching for this "loop" mentioned earlier in the thread?

Thanks,

Dave