WHAT DOES 'DATA SOURCE REFERENCE NOT VALID' MEAN?

T

twerp

I am trying to create a pivot table and I keep getting the message "Data
source reference is not valid". What is that referring to?
 
P

Pierre

I am trying to create a pivot table and I keep getting the message "Data
source reference is not valid". What is that referring to?
Click to expand...

One thought Twerp: One or more of your columns may have a blank in the
column heading, or the ranges you've selected are not arranged in a
grid.
You'll need headings on all columns selected for inclusion in the PT.

If it persists, check out Debra Dalgleishes(sp?) fine website on pivot
tables, or post back more information here.
Pierre
 

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

Error "invalid data source reference" for pivot table 5
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table Source 3
Pivot Table "Data source reference is not valid" error cause? 1
Changing Pivot Table Source Data 1
Can Excel Rtrn a Value by Referencing Multiple Rows and Columns 2
Referencing a pivot tables Grand Totals Column 1
Pivot table data source 1

Top