Reporting and Analysis
for GoldMine CRM and QuoteWerks quote management
Support Center > Knowledge base> Article: "Not Enough Memory or ""Out of Memory"" when creating or refreshing in Office 2000 or Office 97. Thi

"Not Enough Memory or ""Out of Memory"" when creating or refreshing in Office 2000 or Office 97. This may occur even if the same report with Office XP has no problems."

Article ID: 31697

Question
"Not Enough Memory or ""Out of Memory"" when creating or refreshing in Office 2000 or Office 97. This may occur even if the same report with Office XP has no problems."

Answer
Excel 2000 and earlier allocated 100 MB of RAM for its full pivot table workspace. Excel XP uses strategies to make more available, but Microsoft documentation is unclear how much. By querying more than that, regardless of what is being displayed in the pivot table, the user runs out of available memory. The limit can be exceeded by refreshing data that has grown to more than 100MB in the course of time, even if the original report was created with less.

Strategies for dealing with this situation:
1. If possible, re-build the report from scratch with fewer fields included in the query, or use filtering to reduce the total number of records queried.
2. Use MSQuery (chapter 6 in the user manual) to reduce the number of fields queried in the existing report.
3. Get Office XP. The same report can be opened and ""upgraded"" within XP, without generating it anew.


filter memory workspace filters MB megabytes size"

related articles

Article Details
Views: 348 Created on: Nov 15, 2016

Please let us know what you think of this article.
Poor
Outstanding