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


Reply
 
Thread Tools Display Modes
  #1  
Old 08-09-2017, 08:03 AM
snikelfritz's Avatar
snikelfritz snikelfritz is offline
Member
 
Join Date: Jun 2011
Location: Yep
Studying for Nope
Favorite beer: Yep
Posts: 26,881
Default Speeding up Excel 2016?

Ugh, it's just so slow to do anything and everything, all these stupid lags to animate formula updates (which I don't want, and disabled, but the lags still seem to be there). Any thoughts on how to make this be faster?
__________________
Buddy, our boy can become President of the USA and we can engineer it. I will get all of Putin's team to buy in on this.
Reply With Quote
  #2  
Old 08-09-2017, 08:09 AM
NormalDan's Avatar
NormalDan NormalDan is offline
Member
CAS
 
Join Date: Dec 2016
Location: NJ
Posts: 4,143
Default

Quote:
Originally Posted by snikelfritz View Post
Ugh, it's just so slow to do anything and everything, all these stupid lags to animate formula updates (which I don't want, and disabled, but the lags still seem to be there). Any thoughts on how to make this be faster?
Reduce vlookups if possible (like just leaving the formula in the first row). Reduce connections to other workbooks.

Orrrr get a nicer computer
Reply With Quote
  #3  
Old 08-09-2017, 08:25 AM
snikelfritz's Avatar
snikelfritz snikelfritz is offline
Member
 
Join Date: Jun 2011
Location: Yep
Studying for Nope
Favorite beer: Yep
Posts: 26,881
Default

Quote:
Originally Posted by NormalDan View Post
Reduce vlookups if possible (like just leaving the formula in the first row). Reduce connections to other workbooks.

Orrrr get a nicer computer
I mean, sure, faster computer, but really, design the damn program to not take 5 times longer to do every damn little thing. How is this an upgrade? You know who needs fancy graphic animations in a spreadsheet? People who have no business using a spreadsheet, those people, so don't design a spreadsheet program for those people....
__________________
Buddy, our boy can become President of the USA and we can engineer it. I will get all of Putin's team to buy in on this.
Reply With Quote
  #4  
Old 08-09-2017, 08:40 AM
NormalDan's Avatar
NormalDan NormalDan is offline
Member
CAS
 
Join Date: Dec 2016
Location: NJ
Posts: 4,143
Default

Quote:
Originally Posted by snikelfritz View Post
I mean, sure, faster computer, but really, design the damn program to not take 5 times longer to do every damn little thing. How is this an upgrade? You know who needs fancy graphic animations in a spreadsheet? People who have no business using a spreadsheet, those people, so don't design a spreadsheet program for those people....
If you took out the fancy formatting options of excel it'd lose much of what makes it useful. If you're happy to give up formatting to gain processing speed and the like you should use SAS/R/etc and then, if relevant, export any final tables to excel for beautifying before distributing.
Reply With Quote
  #5  
Old 08-09-2017, 08:44 AM
MountainHawk's Avatar
MountainHawk MountainHawk is online now
Member
CAS AAA
 
Join Date: Dec 2001
Location: Salem, MA
Studying for Nothing!!!!
College: Lehigh University Alum
Favorite beer: Yuengling
Posts: 64,814
Default

Quote:
Originally Posted by NormalDan View Post
If you took out the fancy formatting options of excel it'd lose much of what makes it useful. If you're happy to give up formatting to gain processing speed and the like you should use SAS/R/etc and then, if relevant, export any final tables to excel for beautifying before distributing.
He's not talking about the formatting of the sheet itself, but the animations of the program itself. Excel 2016 is annoying.
__________________

Play in the AO Prediction Game now!



1
Reply With Quote
  #6  
Old 08-10-2017, 12:45 AM
diegol diegol is offline
Member
 
Join Date: May 2002
Posts: 237
Default

Quote:
Originally Posted by MountainHawk View Post
He's not talking about the formatting of the sheet itself, but the animations of the program itself. Excel 2016 is annoying.
How 'bout this?

https://support.office.com/en-us/art...0-22CEF9FA025A

It worked for me under Win7 + Office 2016.

Not sure if there are other fancy features that might be slowing down Excel, but animations are no longer there.

Good on ya for starting this thread anyway.
__________________
Diegol
Reply With Quote
  #7  
Old 08-10-2017, 08:57 AM
snikelfritz's Avatar
snikelfritz snikelfritz is offline
Member
 
Join Date: Jun 2011
Location: Yep
Studying for Nope
Favorite beer: Yep
Posts: 26,881
Default

Quote:
Originally Posted by diegol View Post
How 'bout this?

https://support.office.com/en-us/art...0-22CEF9FA025A

It worked for me under Win7 + Office 2016.

Not sure if there are other fancy features that might be slowing down Excel, but animations are no longer there.

Good on ya for starting this thread anyway.
Thanks, that was one of the first things I did, hated the animations. It seems to just be re-calculating things takes longer like it's somehow become less efficient with the upgrade.
__________________
Buddy, our boy can become President of the USA and we can engineer it. I will get all of Putin's team to buy in on this.
Reply With Quote
  #8  
Old 08-17-2017, 11:24 AM
Woodrow's Avatar
Woodrow Woodrow is offline
Member
SOA
 
Join Date: Oct 2002
Posts: 5,715
Default

Has anyone noticed the new error messages?

"You made a mistake in your formula. Do you know what a formula is? A formula is a math thing that starts with an equal sign"

Reply With Quote
  #9  
Old 08-17-2017, 12:19 PM
Childish Gambino's Avatar
Childish Gambino Childish Gambino is online now
Member
SOA
 
Join Date: Jul 2014
Posts: 19,514
Default

wow, I'm still dreading our "upgrade" to 2013.

2010 was the pinnacle of Office.
__________________
Quote:
Originally Posted by Pseudolus View Post
Trump's biggest weakness is that he utterly lacks the knowledge, experience, interest, attention span, temperament, and common decency to be the marginally effective President of a reasonably-large HOA.
Reply With Quote
  #10  
Old 08-17-2017, 12:25 PM
Egghead's Avatar
Egghead Egghead is online now
Member
SOA
 
Join Date: Aug 2006
Posts: 5,456
Default

Quote:
Originally Posted by Childish Gambino View Post
wow, I'm still dreading our "upgrade" to 2013.

2010 was the pinnacle of Office.
I miss Excel 97. I was much more effective with PivotTables using that version. The versions since then have made it possible for folks who barely "get" Excel to create pretty-looking Pivots, but have made it tougher to do anything complex with one.
Reply With Quote
Reply

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 01:11 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.23390 seconds with 9 queries