PDA

View Full Version : Error Updating Pivot Table



torrione73
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:
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

Pecoflyer
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)