+ Reply to Thread
Results 1 to 2 of 2

Default pivot filter to the first item on opening workbook

  1. #1
    Registered User
    Join Date
    02-10-2013
    Location
    UAE
    MS-Off Ver
    Excel 2010
    Posts
    26

    Default pivot filter to the first item on opening workbook

    Hi,

    I'm not sure if this is possible without using programming which would be great, but if not, appreciate if I anyone can assist with the following task:

    I have a pivot that has a dynamic inventory code field in the report filter (also is a slicer on the report page for user to select an item from this field) and I wish for this to select the first item by default when the workbook is opened. For now, it currently selects the item that was last selected before the workbook was saved and closed (which could be an issue if the item is no longer available in this field). Is this possible?

    Thanks in advance.
    Last edited by kev_33; 03-01-2015 at 03:58 AM.

  2. #2
    Registered User
    Join Date
    02-10-2013
    Location
    UAE
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Default pivot filter to the first item on opening workbook

    Any ideas anybody? Appreciate any assistance if possible

+ 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. Hide a Pivot filter item
    By FixandFoxi in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-29-2013, 07:09 AM
  2. Default to most current date in Pivot Filter
    By camdameron in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2013, 08:49 AM
  3. Opening Workbook to a Default Cell
    By The Phil in forum Excel General
    Replies: 1
    Last Post: 11-04-2010, 07:13 PM
  4. Replies: 2
    Last Post: 11-22-2008, 09:59 PM
  5. VBA Issue / Setting Pivot Field Page Default Item
    By AndreLaplume in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-20-2007, 02:38 PM

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