View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Pivot Table "Data source reference is not valid" error cause?

Hi Bill

One possibility, the source range has become invalidated because rows have
been deleted.
Right click on any cell within PTPT WizardBackcheck the source range
--
Regards
Roger Govier

"Bill Neurohr" <Bill wrote in message
...
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?