+ Reply to Thread
Results 1 to 2 of 2

Pivot table missing row labels for Random select few items

  1. #1
    Registered User
    Join Date
    12-14-2015
    Location
    Alberta
    MS-Off Ver
    2007
    Posts
    7

    Pivot table missing row labels for Random select few items

    In our payroll file the pivot table keeps leaving out data. It's for a payroll file, there are 5 report filters, 4 row labels (employee name, emp#, job#, and a cost code) and 3 values.
    It's in outline form and the 4 row labels are grouped in 2 rows. If it makes any difference the file gets saved and opened from a small server in the office here.
    So basically what has been happening is every person will show up on the table, but randomly it will leave out row labels for a single or random few people (for example employee name will show up, but not emp#, job# or cc). Refreshing the table has no effect, but if I clear the table and rebuild it everything seems to be back. Which you'd think - problem solved. Except she opens the file the next day and another completely different employee is now missing name/job#. I thought maybe there was an issue with the source data. Except after rebuilding everything seems to be there, and when the issue comes up its always a different person/people.
    I can not be posting an example of the file sorry. If you have any questions please let me know, I'll do my best to give you a good description.

  2. #2
    Registered User
    Join Date
    12-14-2015
    Location
    Alberta
    MS-Off Ver
    2007
    Posts
    7

    Re: Pivot table missing row labels for Random select few items

    Once again this forum has been an amazing help! Thank you for all the replies!
    Just in case someone is searching google for this issue, I believe my issue arose from adding data to existing cells rows in the source worksheet (there was a hidden column with the year, which was missing for some cells). I'm not sure why it does it but I've had it happen before with other pivot tables.
    From what I'm hearing the table is accurate since the last rebuild.

+ 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. Pivot Table select all Pivot Items not working as intended
    By rasonline in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-13-2014, 05:22 PM
  2. [SOLVED] Pivot table- Select only items having two different variables
    By Excel Dumbo in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 05-13-2013, 07:21 PM
  3. Select all items in pivot table in VBA
    By JohnSeito in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2013, 04:42 AM
  4. Replies: 0
    Last Post: 07-03-2012, 11:09 AM
  5. Pivot Table-Select Pivot Items
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2011, 01:20 PM
  6. Pivot Table - Select Multiple Items not ticked
    By noddy in forum Excel General
    Replies: 5
    Last Post: 03-29-2011, 10:54 AM
  7. Select and unselect items in a filter in pivot table
    By TPFKAS in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-10-2010, 09:39 AM
  8. [SOLVED] Macro - Pivot Table - Select Items
    By S Sainsbury in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-18-2005, 11:30 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1