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

Referencing a pivot tables Grand Totals Column 1
Move and Copy Pivot Table and Source Data 4
Reference is not valid for Pivot tables 2
Pivot Table Help 1
How can I change the source data reference to another pivot table? 2
Pivot Table "Field Name is not valid" error 4
Pivot Table Variance 2
PIVOT TABLE HELP (PLEASE) - REPOST 1

Top