+ Reply to Thread
Results 1 to 4 of 4

Dynamic Pivot table not working correctly

  1. #1
    Registered User
    Join Date
    02-15-2019
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    2

    Dynamic Pivot table not working correctly

    Hi all,

    I have a dynamic pivot table using the following: =OFFSET(DATA!$A$3,0,0,COUNTA(DATA!$A:$A),COUNTA(DATA!$3:$3))

    For some reason it is not picking up the very last line which is making some of the calculations wrong.

    Does anyone have any idea what is causing this?

    Thanks

    Neil

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,575

    Re: Dynamic Pivot table not working correctly

    I'd guess you have a blank cell in column A somewhere. I'd suggest you use a Table unless you have a particular reason for avoiding it.
    Rory
    I drink, and I know things

  3. #3
    Registered User
    Join Date
    02-15-2019
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Dynamic Pivot table not working correctly

    Rorya,

    Thanks for the quick reply....

    I had already checked for that but that isnt the cause.

    Im not sure what you mean when you say to use a table.

    Neil

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,575

    Re: Dynamic Pivot table not working correctly

    If you set your range up as a Table, you can use that as the source for the pivot. It will automatically include all data in the table as it grows.

+ 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: 08-02-2017, 10:16 AM
  2. Dynamic Filter of Data Cube Pivot Table through VBA (last post isn't working)
    By puddingmancan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2015, 04:49 AM
  3. Pivot Chart Value displayed as percentages not working correctly
    By sherry1067 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-19-2014, 12:24 PM
  4. [SOLVED] Dynamic name range not working correctly
    By Nitefox in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 10
    Last Post: 12-14-2013, 09:09 PM
  5. [SOLVED] Vlookup in a table -not working correctly-HELP!!
    By barbibchn in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-14-2013, 07:49 PM
  6. Refresh Pivot Table Data Not Working Correctly
    By robertguy in forum Excel General
    Replies: 3
    Last Post: 10-01-2007, 09:11 AM
  7. Replies: 3
    Last Post: 03-01-2006, 10:30 AM

Tags for this Thread

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