Actuarial Outpost Bump Whenever Excel Crashes
 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

 Upload your resume securely at https://www.dwsimpson.com to be contacted when our jobs meet your skills and objectives.

#21
10-09-2009, 01:49 PM
 ADoubleDot Member SOA Join Date: Nov 2007 Location: Slightly Dusty South Studying for the rest of my life Posts: 37,151

Quote:
 Originally Posted by SirVLCIV I got this crash twice yesterday. Ugh. http://www.pcreview.co.uk/forums/thread-3728376.php It's been awhile, my old friend. At least I only lost 5 minutes of work THIS time.
I don't get it. I use that function all the time. What conditions cause it?
__________________

**** Juan.
#22
10-10-2009, 10:18 PM
 SirVLCIV Member SOA Join Date: Feb 2006 Posts: 46,909

Quote:
 Originally Posted by ADoubleDot I don't get it. I use that function all the time. What conditions cause it?
I'm never able to reproduce it when I want to, but it occurred when I had four large spreadsheets open at once, and used the VLOOKUP function from one spreadsheet on a range of cells in another spreadsheet. Probably a memory issue?

I didn't lose much, and it's not the type of situation I find myself in normally.
#23
10-10-2009, 10:27 PM
 campbell Mary Pat Campbell SOA AAA Join Date: Nov 2003 Location: NY Studying for duolingo and coursera Favorite beer: Murphy's Irish Stout Posts: 85,139 Blog Entries: 6

You must not have been holding your eyebrows =just=right= when you entered that formula.
__________________
It's STUMP

#24
10-14-2009, 04:38 PM
 Piranha Member Join Date: May 2009 Favorite beer: Cabernet Posts: 916

Trying to hide subtotals in a pivot table. Twice in a row, and I'm sure I could easily repeat it with the same data. Once upon a time I'd passionately try to figure out what caused the problem. But the site I'm at is using Excel 2003, so I'll assume it's been fixed by now.

"Thanks Bill!" is our cheer everytime anything in Office or Visual Studio either crashes or does something "on my behalf for my convenience", like Microsoft Word [almost irreversibly] indenting three pages of text because I hit tab.
__________________
#25
10-30-2009, 03:02 PM
 KandaBer Member SOA AAA Join Date: Nov 2006 Studying for FSA Modules Posts: 696

Can we make this a sticky?
#26
10-31-2009, 01:53 AM
 Brad Gile Member CAS SOA AAA Join Date: Sep 2001 Studying for whatever I feel like College: Alumnus of Brown and UW-Madison Posts: 11,341

Quote:
 Originally Posted by Piranha Trying to hide subtotals in a pivot table. Twice in a row, and I'm sure I could easily repeat it with the same data. Once upon a time I'd passionately try to figure out what caused the problem. But the site I'm at is using Excel 2003, so I'll assume it's been fixed by now. "Thanks Bill!" is our cheer everytime anything in Office or Visual Studio either crashes or does something "on my behalf for my convenience", like Microsoft Word [almost irreversibly] indenting three pages of text because I hit tab.
You have VS at work? CONGRATULATIONS! I'm retired, but at my last company, VS was forbidden even for IT people. We did, however, have the .NET Framework with XP, so I used the VB and C# compilers for my own clandestine use from time to time.
__________________
Affiliate Member of the CAS
Dedicated Retired Actuary

Spoiler:
Obama sucks and we all know it-TDA

Spoiler:

That's been the funniest subplot of this whole thing, the people on the left attacking this bill for not being even more of a steaming pile. - erosewater
#27
11-06-2009, 05:35 PM
 ADoubleDot Member SOA Join Date: Nov 2007 Location: Slightly Dusty South Studying for the rest of my life Posts: 37,151

Quote:
 Dear A.., F-you buddy! Now you have to work this weekend. Up Yours, M\$ Excel
__________________

**** Juan.
#28
11-06-2009, 05:55 PM
 campbell Mary Pat Campbell SOA AAA Join Date: Nov 2003 Location: NY Studying for duolingo and coursera Favorite beer: Murphy's Irish Stout Posts: 85,139 Blog Entries: 6

Excel didn't crash per se, but it was interfering with my other stuff as it was autosaving a huge spreadsheet every ten minutes.

You better believe I switched that setting.
__________________
It's STUMP

#29
11-06-2009, 06:30 PM
 ShakeNBakes Official AO Ninja Join Date: May 2005 Location: you can't see me Studying for my next eye exam Favorite beer: Guinness - because it's color of ninjas. And delicious. Posts: 15,881

when you say huge, how big do you mean? I've got a couple spreadsheets I think are quite large, and I've always wondered how they stack up across the biz.
#30
11-06-2009, 06:31 PM
 campbell Mary Pat Campbell SOA AAA Join Date: Nov 2003 Location: NY Studying for duolingo and coursera Favorite beer: Murphy's Irish Stout Posts: 85,139 Blog Entries: 6

large enough that it takes about a minute to save.

That's very annoying.
__________________
It's STUMP

 Tags data science