Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions


Not looking for a job? Tell us about your ideal job,
and we'll only contact you when it opens up.
https://www.dwsimpson.com/register


Reply
 
Thread Tools Display Modes
  #21  
Old 10-09-2009, 01:49 PM
ADoubleDot's Avatar
ADoubleDot ADoubleDot is offline
Member
Non-Actuary
 
Join Date: Nov 2007
Location: Slightly Dusty South
Studying for the rest of my life
Posts: 37,035
Default

Quote:
Originally Posted by SirVLCIV View Post
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?
__________________
ADoubleDot: I'm an actuarial icon.

**** Juan.
Reply With Quote
  #22  
Old 10-10-2009, 10:18 PM
SirVLCIV's Avatar
SirVLCIV SirVLCIV is offline
Member
SOA
 
Join Date: Feb 2006
Posts: 46,905
Default

Quote:
Originally Posted by ADoubleDot View Post
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.
Reply With Quote
  #23  
Old 10-10-2009, 10:27 PM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 79,353
Blog Entries: 6
Default

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

LinkedIn Profile
Reply With Quote
  #24  
Old 10-14-2009, 04:38 PM
Piranha's Avatar
Piranha Piranha is offline
Member
 
Join Date: May 2009
Favorite beer: Cabernet
Posts: 913
Default

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.
__________________
Thank you for your time.
Reply With Quote
  #25  
Old 10-30-2009, 03:02 PM
KandaBer KandaBer is offline
Member
SOA AAA
 
Join Date: Nov 2006
Studying for FSA Modules
Posts: 672
Default



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

Quote:
Originally Posted by Piranha View Post
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.
__________________
Brad Gile, FSA, MAAA
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
Reply With Quote
  #27  
Old 11-06-2009, 05:35 PM
ADoubleDot's Avatar
ADoubleDot ADoubleDot is offline
Member
Non-Actuary
 
Join Date: Nov 2007
Location: Slightly Dusty South
Studying for the rest of my life
Posts: 37,035
Default

Received this note just as I was about to leave today:

Quote:
Dear A..,

F-you buddy! Now you have to work this weekend.

Up Yours,
M$ Excel
__________________
ADoubleDot: I'm an actuarial icon.

**** Juan.
Reply With Quote
  #28  
Old 11-06-2009, 05:55 PM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 79,353
Blog Entries: 6
Default

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

LinkedIn Profile
Reply With Quote
  #29  
Old 11-06-2009, 06:30 PM
ShakeNBakes's Avatar
ShakeNBakes ShakeNBakes is offline
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,855
Default

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.
Reply With Quote
  #30  
Old 11-06-2009, 06:31 PM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 79,353
Blog Entries: 6
Default

large enough that it takes about a minute to save.

That's very annoying.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
Reply

Tags
data science

Thread Tools
Display Modes

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 12:09 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, 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.28721 seconds with 9 queries