+ Reply to Thread
Results 1 to 3 of 3

Pivot doesn't show data

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    4,062

    Pivot doesn't show data

    Below is the code I'm using to create a pivot table. Everything works fine, but the finished pivot table only shows the headings. To get it to show the data I have to go to one of the PivotFields and deselect something. Then my table updates. Then I can reselect what I deselected, and all my data is there. I can't understand why. I'd post an example but it's a huge file, so hopefully you'll see something in my code that's wonky. I'd appreciate any help I can get.

    Thanks,
    John
    Please Login or Register  to view this content.
    Last edited by jomili; 08-30-2011 at 08:41 AM.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,985

    Re: Pivot doesn't show data

    It shouldn't be an issue, but I would try adding:
    Please Login or Register  to view this content.
    after the
    Please Login or Register  to view this content.
    line.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    4,062

    Re: Pivot doesn't show data

    Romper,

    Sorry it took me so long to get back to you. I found/corrected problem; apparently my data source was too big. The pivot table was hitting the limits on rows. Turning off one pivotitem allowed the pivot to work (but it wouldn't work when I added it back in, though it looked like it worked), so now I've put in some routines to trim down the source data more. We're only a week away from the end of our fiscal year, so this pivot is crunching a LOT of data.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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