Pivot Table "Data source reference is not valid" error cause?

B

Bill Neurohr

What causes this error:

"Data source reference is not valid"

when I'm trying to insert a Pivot Table from simple Excel data that is
properly formatted with no blank cells and appropriate headers as column
labels?
 
R

Roger Govier

Hi Bill

One possibility, the source range has become invalidated because rows have
been deleted.
Right click on any cell within PT>PT Wizard>Back>check the source range
 

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 cell values 1
Excel 2007 pivot table using analysis services cube as data source 0
Referencing a pivot tables Grand Totals Column 1
Cumulative formula for word table 0
Pivot tabel field name not valid in 2007, was in 2003 0
Pivot Table Counting Text Data 0
Pivot Table - Row Label Combination 0

Top