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

Pivot Table with Data Model Connection - getpivotdata reference issue 0
Cross reference drop down not activating 1
Custom reference in Word 2016 2
Excel 2013 Pivot Data Range formula reference problem 0
Error "invalid data source reference" for pivot table 5
Embed the same Excel multiple times 0
Office 365 Outlook adding unwanted HTML to Email Body 0
what does "data source reference is not valid' in Pivot table 1

Top