Not enough memory for large workbooks

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

In my job, we have large workbooks containing many tabs and many
formulas. We are having a problem with these large workbooks and we
get an error message of "NOT ENOUGH MEMORY" when we try to open and/or
save these large workbooks. Is here an easy fix to this problam?
 
Kevin said:
In my job, we have large workbooks containing many tabs and many
formulas. We are having a problem with these large workbooks and we
get an error message of "NOT ENOUGH MEMORY" when we try to open and/or
save these large workbooks. Is here an easy fix to this problam?
Click to expand...

To my knowledge no, Excel can handle millions of cells on a worksheet
but not alot of worksheets. The best you can do (that I know of) is find
out how many worksheets your workbook can handle and then move the rest
of the worksheets over to a new workbook. Ugly? Yes, and if someone has
another solution I want to know as well.
 
Back
Top