Error Updating Pivot Table

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:
Tabella_Query_da_CAEM_globale_18marzo09[#Tutto]


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


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


Thanks Francesco

Please do not post the same question in different forums without links .

read this to understand why and add links to ALL other forums you posted on ( besides MsOffice forums)