+ Reply to Thread
Results 1 to 3 of 3

PivotTable 2011: with what to replace timeline

  1. 03-23-2016, 12:35 PM #1
    R12345
    R12345 is offline
    Registered User
    Join Date
    02-07-2016
    Location
    Canada
    MS-Off Ver
    13
    Posts
    65

    PivotTable 2011: with what to replace timeline

    Hi everyone,

    There is a problem that drives me crazy. I have a pivot table I sent to a person who has excel 2011 (mac).
    In my Pivot I need to use timeline (I have to filter data by specific dates/by weeks/by months/by years).
    Damn excel 2011 does not allow me to use Pivot Timelines.
    Is there a way to replace it with something?
    Maybe VBA filters?
    Please help me with it...

    Thanks!
    Last edited by R12345; 03-23-2016 at 12:42 PM.
    Reply With QuoteRegister To Reply
  2. 03-23-2016, 03:05 PM #2
    R12345
    R12345 is offline
    Registered User
    Join Date
    02-07-2016
    Location
    Canada
    MS-Off Ver
    13
    Posts
    65

    Re: PivotTable 2011: with what to replace timeline

    Does someone know any ways to do it?
    Reply With QuoteRegister To Reply
  3. 03-23-2016, 03:06 PM #3
    R12345
    R12345 is offline
    Registered User
    Join Date
    02-07-2016
    Location
    Canada
    MS-Off Ver
    13
    Posts
    65

    Re: PivotTable 2011: with what to replace timeline

    How can you select data by time without having to filter it by clicking on all dates you need and without ability to use tile slices in Pivot Table?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA 2010 / VBA 2011 search/find function won't work in 2011 (MAC)
    By lafanker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2014, 09:02 AM
  2. Trying to find and replace hidden characters in Excel 2011 for OSX, not succeeding
    By xdriver in forum Excel General
    Replies: 2
    Last Post: 03-21-2014, 11:32 AM
  3. Add Project Timeline With Charts and Comparisons Excel 2011 for Mac
    By kikaas in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 10-10-2013, 07:22 AM
  4. Shift rows below PivotTable down when PivotTable expands (PowerPivot)
    By hektisk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2012, 10:19 PM
  5. [SOLVED] Macro/vba to change date format from 01.01.2011 to 01/01/2011
    By Darrenh1238 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-20-2012, 07:42 PM
  6. Convert Date - 8/29/2011 to 2011.08.29
    By artiststevens in forum Excel General
    Replies: 4
    Last Post: 08-29-2011, 06:10 AM
  7. Help with Date Macros - eg. Change Values From Jun 5, 2011 to 05/06/2011
    By Red2Black in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-14-2011, 08:44 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1