+ Reply to Thread
Results 1 to 2 of 2

Pivot Table from a table - not picking up full range

  1. #1
    Registered User
    Join Date
    01-29-2020
    Location
    London
    MS-Off Ver
    2016
    Posts
    1

    Pivot Table from a table - not picking up full range

    I have a large table on one sheet in an excel workbook. Whenever I run a pivot table off of this table, it picks up the whole table except the top 50 or so rows. If I alter my pivot table source data to capture the whole table excluding the last row (i.e. the cells themselves, rather than the table as a collective, it works fine).
    Any suggestions?

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,912

    Re: Pivot Table from a table - not picking up full range

    Do you mean that if you use the table as a reference, you get the right field names, but the first 50 data rows aren’t included, or are the field names wrong?
    Rory

+ 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: 1
    Last Post: 12-05-2019, 03:47 AM
  2. [SOLVED] Paste Pivot Table Values and Keep Full Formatting (Excel 2013)
    By greatjobtoday in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-26-2015, 11:03 AM
  3. [SOLVED] Pivot Table No Longer Picking Up Data
    By JakeMann in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-16-2015, 09:14 AM
  4. How to show full totals in Pivot chart and table when you filter on one customer?
    By newbieexcelgirl in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-12-2012, 06:30 PM
  5. Pivot table, show full range of data
    By demonkogura in forum Excel General
    Replies: 5
    Last Post: 04-21-2012, 01:54 AM
  6. Replies: 5
    Last Post: 01-06-2012, 04:35 PM
  7. Return pivot table range...not the data table, the PIVOT TABLE!
    By Air_Cooled_Nut in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2008, 01:07 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