+ Reply to Thread
Results 1 to 2 of 2

Change pivot table default options (more than formatting)

  1. #1
    Forum Contributor
    Join Date
    08-07-2015
    Location
    AB, Canada
    MS-Off Ver
    Excel 2013 x64
    Posts
    132

    Change pivot table default options (more than formatting)

    Two main sections to my questions.

    (1) Ideally, I'd like to have any new pivot table I create open in Classic layout.

    (2) If I can't change (1) into the default, I'd like to be able to change the default options for subtotals and report layout to make it more familiar for the user I'm helping.

    Any thoughts how to accomplish this? Thanks.

  2. #2
    Forum Contributor
    Join Date
    08-07-2015
    Location
    AB, Canada
    MS-Off Ver
    Excel 2013 x64
    Posts
    132

    Re: Change pivot table default options (more than formatting)

    If someone finds a way to change the default settings, let me know. For now, I'm using an add-in I put together that allows you to use the shortcut "Ctrl+Shift+P" whenever you have selected any cell that's part of a pivot table and it will turn that pivot table into classic mode without having to navigate all the windows.

    In case someone else is looking for a similar solution:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 09-11-2013, 10:22 AM
  2. [SOLVED] How to change Pivot Table default?
    By GIS2013 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 09-09-2013, 09:41 AM
  3. How to change the default calculation in a Pivot Table?
    By GIS2013 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-07-2013, 09:44 AM
  4. Pivot Table Value Field Settings Default Options
    By Bill fitz in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-07-2013, 09:23 AM
  5. Change Default Formatting of Pivot Drill-Down Data
    By lsofia in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-31-2012, 09:53 AM
  6. Pivot Table Default Change
    By novodisc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-30-2011, 10:50 PM
  7. Pivot Table Default Change
    By bluerog in forum Excel General
    Replies: 1
    Last Post: 01-12-2010, 09:39 AM
  8. Pivot Table - Default Settings for Table Options
    By Nacho in forum Excel General
    Replies: 0
    Last Post: 02-25-2005, 02:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1