Excel 2007, creating a pivot table and i get this message: data source reference is not valid

i have tried this a couple of times and get the same message.  I have created the reference manually as well as let it default and i get the same message.

Any ideas are appreciated.

 

Question Info


Last updated December 31, 2019 Views 111,810 Applies to:
Answer
Answer
Open the Excel spreadsheet click on the view tab and select new window. Save the spreadsheet with a different name for the new window.

114 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.