+ Reply to Thread
Results 1 to 3 of 3

PIVOT Table: the command requires at least two rows of source data

  1. #1
    Registered User
    Join Date
    04-06-2013
    Location
    orategnWinchester
    MS-Off Ver
    Excel 2003
    Posts
    7

    PIVOT Table: the command requires at least two rows of source data

    Hello,

    I have a pivot table, however when I try to update the pivot table data by using the refresh function it gives me the above error?

    Is there anyway around this? Is there anyway I can get the pivot table to count the number of blank cells?

    Thanks

    A
    Last edited by arnold869; 09-14-2013 at 12:41 PM.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: PIVOT Table: the command requires at least two rows of source data

    Check the source data for the Pivot Table. Does it reference headings and at least one row of data?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    04-06-2013
    Location
    orategnWinchester
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: PIVOT Table: the command requires at least two rows of source data

    As far as I know there is one heading and the table only has one row of data?

+ 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: 0
    Last Post: 08-14-2013, 06:31 AM
  2. Replies: 8
    Last Post: 04-08-2013, 08:14 AM
  3. Pivot table - change data source to another pivot table in 2010
    By thesecretsanta in forum Excel General
    Replies: 4
    Last Post: 04-13-2011, 12:54 PM
  4. Replies: 1
    Last Post: 06-22-2010, 09:10 AM
  5. Replies: 1
    Last Post: 06-20-2010, 04:00 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