Inrease maximum memory in Excel?

O

OldManExcellor

New Member
Joined
May 30, 2011
Messages
45
I'm trying to create a pivot table of 5 million rows, but Excel says it's out of memory.

The Excel file is 400 MB. I'm sitting at a quad core laptop with 8 GB RAM so I would think that it should be able to create the pivot table.

Is there any way to increase the maximum memory in Excel? Or is there any other clever way around this?
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Sort by date Sort by votes
Five million rows? Excel only has one million.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question Question
Memory resource issue when opening and closing excel files
Replies
0
Views
290
Mike UK
M
N
  • Question Question
Pivot Table Issues After Applying Formats
Replies
0
Views
518
Nordicrx8
N
R
  • Question Question
VBA Performance / Optimization & Out of Memory Error
Replies
9
Views
2K
Candyman8019
C
N
  • Question Question
Column with Min/Average values at the end of Pivot Table
Replies
0
Views
161
Nurces
N
M
  • Question Question
Ideas Power Query and/or Python?
Replies
8
Views
568
mickeystanford_alumni
M

Forum statistics

Threads
1,224,552
Messages
6,179,487
Members
452,917
Latest member
MrsMSalt

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top