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?
 
Ad

Advertisements

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

Top