+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Not Pulling 2014 Dates

  1. #1
    Registered User
    Join Date
    11-02-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    26

    Pivot Table Not Pulling 2014 Dates

    Hi There,

    I have a pivot table that pulls data from a source table using a series of filters. But most important of all the filters is the 'Year' filter. Without a date in the 'Period' column of the source data, none of the other data linked to it will be pulled by the pivot table through the 'Year' filter.

    I have dates ranging from 2009 - 2014 and up until recently all those dates have been feeding into the Pivot Table. But since the start of the week the 2009 -2011 dates and 2014 dates are no longer being pulled by the table.

    I've tried and checked everything known to me. Are there any suggestions people can give me to trouble shoot this?

    I cannot share the data source as it's highly sensitive information.

    Any help would be much appreciated.

    Rgds,

    Oscar.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,344

    Re: Pivot Table Not Pulling 2014 Dates

    What would you have us look at to diagnose the problem?


    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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: 3
    Last Post: 01-30-2014, 08:19 PM
  2. [SOLVED] Pulling out Top 10 from a Pivot Table.
    By davidx in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-30-2013, 08:06 AM
  3. Need help pulling data into pivot table
    By do00103 in forum Excel General
    Replies: 1
    Last Post: 05-08-2012, 11:42 PM
  4. Pulling data for a pivot table
    By burnsbe in forum Excel General
    Replies: 1
    Last Post: 09-08-2010, 10:58 AM
  5. Pivot table pulling wrong value
    By RestlessAde in forum Excel General
    Replies: 1
    Last Post: 11-25-2005, 02:35 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