torrione73
New member
- Joined
- Jul 28, 2016
- Messages
- 1
- Reaction score
- 0
- Points
- 0
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
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