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 Search this Thread Display Modes
  #11  
Old 08-17-2017, 01:30 PM
Childish Gambino's Avatar
Childish Gambino Childish Gambino is offline
Member
SOA
 
Join Date: Jul 2014
Posts: 25,647
Default

Quote:
Originally Posted by Egghead View Post
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.
I was also very partial to the 2003 version. I think the positives outweigh the negatives for things like the modern formats which save disk space, the additional rows which are frequently useful, and the ribbon is better once you get used to it.

The pivot tables have a "classic layout" option in there that will get you back to the old style. I use it frequently because I agree with you. Here is a macro to take you there that I keep in my personal book

Code:
Sub PivotDefaults()
'
' PivotDefaults Macro
'
    For Each pt In ActiveSheet.PivotTables
        With pt
            .InGridDropZones = True
            .RowAxisLayout xlTabularRow
        End With
        pt.TableStyle2 = ""
    Next
End Sub
__________________
When fascism comes to America, it will be wrapped in the US Flag and carrying a Cross.
Reply With Quote
  #12  
Old 08-17-2017, 02:58 PM
snikelfritz's Avatar
snikelfritz snikelfritz is offline
Member
 
Join Date: Jun 2011
Location: Yep
Studying for Nope
Favorite beer: Yep
Posts: 27,409
Default

Quote:
Originally Posted by Woodrow View Post
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"

I might straight up punch my computer if it ever has the gall to tell me that.
__________________
The universe is a cruel uncaring void, the key to being happy isn't the search for meaning, it's to just keep yourself busy with unimportant nonsense and eventually, you'll be dead.
Reply With Quote
  #13  
Old 08-17-2017, 03:28 PM
Woodrow's Avatar
Woodrow Woodrow is offline
Member
SOA
 
Join Date: Oct 2002
Posts: 6,843
Default

Quote:
Originally Posted by snikelfritz View Post
I might straight up punch my computer if it ever has the gall to tell me that.
Put in something like

=A1"hello"

with no & between them....
Reply With Quote
  #14  
Old 08-17-2017, 03:44 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: 64,850
Default

Quote:
Originally Posted by Childish Gambino View Post
I was also very partial to the 2003 version. I think the positives outweigh the negatives for things like the modern formats which save disk space, the additional rows which are frequently useful, and the ribbon is better once you get used to it.

The pivot tables have a "classic layout" option in there that will get you back to the old style. I use it frequently because I agree with you. Here is a macro to take you there that I keep in my personal book

Code:
Sub PivotDefaults()
'
' PivotDefaults Macro
'
    For Each pt In ActiveSheet.PivotTables
        With pt
            .InGridDropZones = True
            .RowAxisLayout xlTabularRow
        End With
        pt.TableStyle2 = ""
    Next
End Sub
Also key to sanity: You can turn off GETPIVOTDATA under File>Options>Formulas
__________________

Play in the AO Prediction Game now!



1
Reply With Quote
  #15  
Old 08-17-2017, 03:49 PM
Childish Gambino's Avatar
Childish Gambino Childish Gambino is offline
Member
SOA
 
Join Date: Jul 2014
Posts: 25,647
Default

Quote:
Originally Posted by MountainHawk View Post
Also key to sanity: You can turn off GETPIVOTDATA under File>Options>Formulas
Also in personal workbook. Sometimes it's useful, sometimes it's annoying. Depends what I'm trying to do
Code:
Sub GenerateGetpivotToggle()
'
' GenerateGetpivotToggle Macro
' Macro recorded 3/31/2010 by Childish Gambino
'
' Keyboard Shortcut: Ctrl+Shift+G
'
    If Application.GenerateGetPivotData Then
        Application.GenerateGetPivotData = False
    Else
        Application.GenerateGetPivotData = True
    End If
    
End Sub
__________________
When fascism comes to America, it will be wrapped in the US Flag and carrying a Cross.
Reply With Quote
  #16  
Old 08-17-2017, 04:24 PM
snikelfritz's Avatar
snikelfritz snikelfritz is offline
Member
 
Join Date: Jun 2011
Location: Yep
Studying for Nope
Favorite beer: Yep
Posts: 27,409
Default

Quote:
Originally Posted by Woodrow View Post
Put in something like

=A1"hello"

with no & between them....
I think it knows what would happen if it treated me like that:

__________________
The universe is a cruel uncaring void, the key to being happy isn't the search for meaning, it's to just keep yourself busy with unimportant nonsense and eventually, you'll be dead.
Reply With Quote
  #17  
Old 08-17-2017, 04:30 PM
redearedslider's Avatar
redearedslider redearedslider is offline
Member
CAS
 
Join Date: Oct 2015
Posts: 13,407
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.
Gonna give this a shot.
__________________
Quote:
Originally Posted by Abraham Weishaus View Post
ASM does not have a discussion of stimulation, but considering how boring the manual is, maybe it would be a good idea.
Reply With Quote
  #18  
Old 08-17-2017, 05:37 PM
Woodrow's Avatar
Woodrow Woodrow is offline
Member
SOA
 
Join Date: Oct 2002
Posts: 6,843
Default

Quote:
Originally Posted by snikelfritz View Post
I think it knows what would happen if it treated me like that:

Yup, that's the one.

the old version didn't have the attitude
Reply With Quote
  #19  
Old 08-18-2017, 01:19 AM
redearedslider's Avatar
redearedslider redearedslider is offline
Member
CAS
 
Join Date: Oct 2015
Posts: 13,407
Default

Anyone use any excel addins like Macabacus?
__________________
Quote:
Originally Posted by Abraham Weishaus View Post
ASM does not have a discussion of stimulation, but considering how boring the manual is, maybe it would be a good idea.
Reply With Quote
  #20  
Old 10-23-2018, 12:59 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: 84,619
Blog Entries: 6
Default

Speaking of speeding up Excel...

https://techcommunity.microsoft.com/...up/ba-p/254199

Quote:
Excel performance improvements now take seconds running Lookup-type functions
This is our second wave of Excel Office 365 performance improvements after our first Sept ’17 one, to reinforce our commitment to fixing top impacting freezing, slow and not responding performance issues derived from Excel user feedback and usage learnings. This time around we have even more improvements than before starting with...


"usage learnings"



I'll try not to hold it against them.

Quote:
Lookup functions VLOOKUP, HLOOKUP, and MATCH are one of the most used functions in Excel. If you use them with exact match to find items in a table or range in Excel, and see it noticeably take time in seconds or minutes or more, chances are you'll now see very noticeable improvement in the speed at which you see results.







We made them faster by more efficiently finding the item you are looking up. We create an index on-demand when you first search of a range of cells and then reuse it in subsequent lookups from the same range, until data changes in the lookup range. For details refer to our updated Excel Performance and limit improvements whitepaper.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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 09:06 PM.


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