Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-28-2016, 02:01 AM
torrione73 torrione73 is offline Pivot Table and Excel 2016 vs 2007 Windows 10 Pivot Table and Excel 2016 vs 2007 Office 2016
Novice
Pivot Table and Excel 2016 vs 2007
 
Join Date: Jul 2016
Posts: 2
torrione73 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 07-28-2016, 06:36 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Pivot Table and Excel 2016 vs 2007 Windows 7 64bit Pivot Table and Excel 2016 vs 2007 Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 07-28-2016, 07:11 AM
torrione73 torrione73 is offline Pivot Table and Excel 2016 vs 2007 Windows 10 Pivot Table and Excel 2016 vs 2007 Office 2016
Novice
Pivot Table and Excel 2016 vs 2007
 
Join Date: Jul 2016
Posts: 2
torrione73 is on a distinguished road
Default

Sorry I didn't Know it was the same forum
Reply With Quote
  #4  
Old 07-28-2016, 07:24 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Pivot Table and Excel 2016 vs 2007 Windows 7 64bit Pivot Table and Excel 2016 vs 2007 Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table and Excel 2016 vs 2007 Excel 2010 Pivot table problem Kris TenEyck Excel 4 02-01-2014 01:26 AM
Pivot Table and Excel 2016 vs 2007 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
Pivot Table and Excel 2016 vs 2007 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:54 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft