#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Please do not cross post without links
Read this to understand why. Please add links to all your cross-posts. Thanks
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Sorry I didn't Know it was the same forum
|
#4
|
||||
|
||||
If you have read the link I gave you you would see that the forums are not the same.
Please take a moment to read the supplied link. Thank you
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
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 |