|
|
#1
07-28-2016, 02:01 AM
|
|||
|
|||
Pivot Table and Excel 2016 vs 2007
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 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Excel 2010 Pivot table problem
|
Kris TenEyck | Excel | 4 | 02-01-2014 01:26 AM |
|
Grouping Dates in Excel Pivot Table
|
mskennedy | Excel | 2 | 02-27-2013 11:09 AM |
| Excel Pivot Table Calculated Field | BertLady | Excel | 0 | 05-21-2012 10:51 AM |
|
Excel 2010 Pivot Table Qs
|
SchneeBaer | Excel | 2 | 10-03-2011 08:45 PM |
| Excel pivot table into an MS Word Doc "office 2007" | wmarsh3561 | Excel | 1 | 01-09-2010 08:03 PM |
Windows 10 
Office 2016
Threaded Mode