Excel not enough memory

[SGT_Spittal]

Good Morning from the UK.

I am having trouble with an excel workbook that I use to create a dashboard.

I am using Excel 2010 and I am downloading from Oracle and passing this into excel.

From this data I am using PowerPivot to generate 9 pivot charts (obviously 1 pivot table per chart) and 1 Pivot table as a printable report.

I have used slicers to give the user the ability to customise the data that is presented, however I get an error message saying that excel is out of memory.

I am wondering, if I was to use a "Command Button" to generate the printable report after the slicers have been set to the required selections would this help?.

Also when I use the "Command Button" how do I get the existing slicer options to affect the new PivotTable

 

[mole999]

what versions of excel are in use, 32bit can only address a set limit, 64 exponentially larger

What size is the download, 10 pivots probably shouldn't exceed limits

what physical RAM levels

when the workbook is closed, what size is it reported at

 

[SGT_Spittal]

32 bit excel 2010 and I think it is 2GB of ram not sure of the size of the download I will have to look but it's a csv file so shouldn't be huge

 

[mole999]

If its a long term problem then go bigger on the RAM, I think 4Gb is the limit

 

[Qwest336]

Good Morning from the UK.

I am having trouble with an excel workbook that I use to create a dashboard.

I am using Excel 2010 and I am downloading from Oracle and passing this into excel.

From this data I am using PowerPivot to generate 9 pivot charts (obviously 1 pivot table per chart) and 1 Pivot table as a printable report.

I have used slicers to give the user the ability to customise the data that is presented, however I get an error message saying that excel is out of memory.

I am wondering, if I was to use a "Command Button" to generate the printable report after the slicers have been set to the required selections would this help?.

Also when I use the "Command Button" how do I get the existing slicer options to affect the new PivotTable

Good morning,

I was having this problem a while back and was able to solve it using a program called 4gb_patch. Basically, after backing up the original executable, this program "patches" the x86 executable allowing it to address 4gb of ram instead of 2gb. If you find that you have 4GB and it's still not enough under 32-bit architecture, it's worth looking into.

Here's the link to the site for the download and the description:

NTCore's Homepage

Hope this helps! And don't forget to back up the original excel executable.