View Full Version : Error Updating Pivot Table

2016-07-28, 11:12 AM
Opening an Excel file ,created with Excel 2007, with Excel 2016 and updating a pivot table i receive the error "Reference not valid".

I see in Pivot Table Tools--->Analyze--->Change Data source that the table/Interval is in this format:

If i remove [#Tutto] the error seems to be solved.

Is this the correct way to solve this comptibility Issue??

Thanks Francesco

2016-07-28, 03:35 PM
Please do not post the same question in different forums without links .

read this (http://www.excelguru.ca/content.php?184) to understand why and add links to ALL other forums you posted on ( besides MsOffice forums)