not enough memory error message

  • Thread starter Thread starter spjoseph0511
  • Start date Start date
S

spjoseph0511

I have a large table in MS Access that I use MS Query to return record
to a pivot table in MS Excel. When returning the data I get an erro
message telling me there is not enough memory.
I tried increasing the virtual memory on my machine, but it didn't hel
much. Please help
 
Excel has various internal memory limits: you have hit one of them.

If you have hit the pivot cache limit you can get more rows if you retrieve
a smaller number of columns.

Also Excel 2003 has a much larger limit, and excel2002 will handle about
twice as much as excel2000/97.

see
http://www.decisionmodels.com/memlimitsc.htm for more info and references
to specific MSKB articles.


Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm
 
Back
Top