Pivot Table

M

Megt

When using a pivot Table and Pivot Chart to put in Excell,
a window comes up and shows this message " This command
requires at least two rows of source data. You cannot use
the command on a selection in only one row. Try the
following: . If you're using an advanced filter, select a
range of cells that contains at least two rows odf
data.Then click the Advanced Filter command again. . If
you're creating a Pivot Table, type a cell reference or
select a range that includes at least two rows data." Can
someone help me with that please.what error is that?
 
D

Debra Dalgleish

In Step 2 of the PivotTable Wizard, do you select a range of cells that
includes a row of headings, and the data for the pivot table?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Pivot Table Data Aggregation 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Connection files and pivot tables 0
Retain pivot table formatting after refreshing data 0
pivot table missing rows? 0
Multiple Tables and Multiple Pivot Tables Help 0
Pre-configuring Pivot table "views" 4

Top