I'm dealing with a spreadsheet that has around 500,000 rows and 100 columns in excel 2011. I would like to generate pivot table report for the entire sheet, but it says there is not enough memory. My current computer has 8 GB ram. What kind of memory would I need to allow excel to do those kind of calculations?
if you're using 32 bit Excel, if I remember correctly, Excel can only utilize up to 4GB of Ram. Do you know how to use MS Access or MS SQL Server?
To thank someone who has helped you, click on the star icon below their name.
I hate reading
Portfolio
I need a job.I am young and incompetent
By the way, I miss Chicago! Moved to SF for 6 months, don't seem to enjoy it.
To thank someone who has helped you, click on the star icon below their name.
I hate reading
Portfolio
I need a job.I am young and incompetent
No don't know how to use that stuff, thinking about learning it now that I can't do this function in excel. I think excel 2011 is 64-bit? I'm not positive. Is there any work around on that? Any way I can utilize my full 8 GB?
Hello
Don't know if this can help you.
http://support.microsoft.com/kb/211515
Creating a PageField will reduce the size.....
Contributors to this forum do not get paid. They give their valuable time to help you solve your problem. That's why feel free to CLICK their STARicon to say thank you -even the given idea/solution didn't really solve your queries. The time given to you deserves a small gratitude anyway.
Dare to give a pencil to a child. http://www.blackpencilproject.org/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks