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