Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
Reload this Page "Not Enough Memory" Error in excel
Register Blogs Wiki FAQ Calendar Search Today's Posts Mark Forums Read
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

D.W. Simpson & Company International Actuary Jobs
  Canada  Asia  Australia  Life  Pension  Casualty
Bermuda, United Kingdom, Europe, Asia, Worldwide


Reply
Page 1 of 2 1 2 >
 
Thread Tools Display Modes
  #1  
Old 10-13-2010, 02:24 PM
T-roy Boy's Avatar
T-roy Boy T-roy Boy is offline
Member
SOA 		 
Join Date: May 2002
Favorite beer: Lagunitas Sucks
Posts: 6,984
Blog Entries: 1
Default "Not Enough Memory" Error in excel
"Not Enough Memory Continue without Undo"

Trying to update a pivot table, obviously there is a lot of data. But this is the first time I am getting an error like the above. Anyone have a quick tip/trick on getting around this? I tried to save the file to my desktop and doing it from my comuter memory (instead of on the mainframe, which worked last month).

TIA
__________________
Spoiler:
Poker Table Builder Extraordinaire
26.2 - WI MARATHON (5/1/10), SANTA BARBARA (11/6/2010), CHICAGO (10/9/2011), NEW YORK (11/6/2011), CHICAGO (10/7/12)[/color]Racine Half Ironman (07/21/13)
Last edited by T-roy Boy; 10-13-2010 at 02:28 PM..
Reply With Quote
  #2  
Old 10-14-2010, 07:38 AM
Steve Grondin Steve Grondin is offline
Member
SOA AAA 		 
Join Date: Nov 2001
Posts: 3,630
Default
In my experience, when I get this message with a file that previously didn't have it (or is clearly smaller than the 4GB of memory on the machine), I have restarted Windows to clear it out.

Sorry I don't have a less severe solution.
Reply With Quote
  #3  
Old 10-14-2010, 08:14 AM
AndrewC's Avatar
AndrewC AndrewC is offline
Member
  
Join Date: Aug 2010
Posts: 852
Default
You may want to use task manager to kill as many applications as possible to free up memory.
__________________
AC.
Reply With Quote
  #4  
Old 10-14-2010, 08:26 AM
MountainHawk's Avatar
MountainHawk MountainHawk is offline
Member
CAS AAA 		 
Join Date: Dec 2001
Location: Salem, MA
Studying for Nothing!!!!
College: Lehigh University Alum
Favorite beer: Yuengling
Posts: 55,598
Default
(1) Reboot Windows
(2) Close down any startup programs you don't absolutely need
(3) Open Excel and try again
__________________


"I am a most unhappy man. I have unwittingly ruined my country. A great industrial nation is now controlled by its system of credit. We are no longer a government by free opinion, no longer a government by conviction and the vote of the majority, but a government by the opinion and duress of a small group of dominant men." -- Woodrow Wilson

It doesn't matter who you vote for, the government always gets in. -- Elizabeth May

???? Jan 20: Freedom for the Bill of Rights

1 2
Reply With Quote
  #5  
Old 10-14-2010, 11:48 AM
Wino In Training Wino In Training is offline
Member
CAS 		 
Join Date: Feb 2002
Location: The Cellar
Posts: 659
Default
Quote:
Originally Posted by MountainHawk View Post
(1) Reboot Windows
(2) Close down any startup programs you don't absolutely need
(3) Open Excel and try again
(4) If your dataset is THAT big, consider moving to Access and doing Crosstab queries instead.
__________________
August 2005 DDT Stars MTT TLB Challenge Winnah!!!
ACOOP 2005/2 HORSE Winner
ACOOP 2004 PoY and Top Money Winner
ACOOP 2004 Stud 8/b & Stud Event Winner
ACOOP 2004 Stud Champ-een!
Reply With Quote
  #6  
Old 10-14-2010, 12:05 PM
JMO's Avatar
JMO JMO is offline
Carol Marler
SOA AAA 		 
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for CPD
Posts: 29,628
Default
Quote:
Originally Posted by Wino In Training View Post
(4) If your dataset is THAT big, consider moving to Access and doing Crosstab queries instead.
Excel 2007 (or 2010) will defer that step for quite a while. Although it does take some time to get used to the ribbon.
__________________
Carol Marler, FSA, MAAA, A Dedicated Actuary
Just My Opinion (Although this statement is my opinion, and I am an actuary, it's still not a statement of actuarial opinion, and you really shouldn't rely on it.)
Updated quotes Apr 4:
Spoiler:
Quote:
Originally Posted by Arthur Kade View Post
Actuaries (as a general rule) are uniquely UNqualified to work with derivatives.
Quote:
Originally Posted by Dr T Non-Fan View Post
learning what the data are, what they mean, why they are plural, etc.
Quote:
Originally Posted by SamTheEagle View Post
StompStomp kept saying "Happy Day!" rather than Happy Birthday. It was cute.
Quote:
Originally Posted by Buck View Post
Machines do not make human-errors but make machine-errors; humans do not make machine-errors but make human-errors ... even when the technology is there, it'd be a tough call as to which makes driving safer.
Quote:
Originally Posted by Klaymen View Post
Life is a bunch of IF statements
Reply With Quote
  #7  
Old 10-14-2010, 12:21 PM
silverfox's Avatar
silverfox silverfox is offline
Member
CAS SOA COPA 		 
Join Date: May 2005
Favorite beer: Westmalle Tripel
Posts: 13,479
Default
Quote:
Originally Posted by JMO View Post
Excel 2007 (or 2010) will defer that step for quite a while. Although it does take some time to get used to the ribbon.
I don't think I'll ever get used to it, but I do like the ribbon for PowerPoint.
Reply With Quote
  #8  
Old 10-14-2010, 12:51 PM
MountainHawk's Avatar
MountainHawk MountainHawk is offline
Member
CAS AAA 		 
Join Date: Dec 2001
Location: Salem, MA
Studying for Nothing!!!!
College: Lehigh University Alum
Favorite beer: Yuengling
Posts: 55,598
Default
Quote:
Originally Posted by Wino In Training View Post
(4) If your dataset is THAT big, consider moving to Access and doing Crosstab queries instead.
That was going to be step 0, but I decided not to be a smartass today.
__________________


"I am a most unhappy man. I have unwittingly ruined my country. A great industrial nation is now controlled by its system of credit. We are no longer a government by free opinion, no longer a government by conviction and the vote of the majority, but a government by the opinion and duress of a small group of dominant men." -- Woodrow Wilson

It doesn't matter who you vote for, the government always gets in. -- Elizabeth May

???? Jan 20: Freedom for the Bill of Rights

1 2
Reply With Quote
  #9  
Old 10-14-2010, 12:51 PM
Been There Done That Been There Done That is offline
Member
  
Join Date: Apr 2002
Posts: 777
Default
Disable Undo and Auto-recover
Reply With Quote
  #10  
Old 10-14-2010, 02:29 PM
Wino In Training Wino In Training is offline
Member
CAS 		 
Join Date: Feb 2002
Location: The Cellar
Posts: 659
Default
Quote:
Originally Posted by JMO View Post
Excel 2007 (or 2010) will defer that step for quite a while. Although it does take some time to get used to the ribbon.
It defers it in terms of being able to address essentially unlimited rows. But it does not address the huge amounts of overhead that doing a PivotTable on said monster dataset takes up. That's what's crushing your memory, not Excel's limitation on rows.

Mantra for work: Use The Right Tool.
__________________
August 2005 DDT Stars MTT TLB Challenge Winnah!!!
ACOOP 2005/2 HORSE Winner
ACOOP 2004 PoY and Top Money Winner
ACOOP 2004 Stud 8/b & Stud Event Winner
ACOOP 2004 Stud Champ-een!
Reply With Quote
Reply
Page 1 of 2 1 2 >

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 01:57 AM.

Contact Us - Actuarial Outpost - Archive - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.21898 seconds with 7 queries