Pivot Table and Excel 2016 vs 2007

		Microsoft Office Forums > Microsoft Excel > Excel
Pivot Table and Excel 2016 vs 2007

FAQ

Thread Tools

Display Modes

07-28-2016, 02:01 AM

torrione73 torrione73 is offline

Windows 10 Pivot Table and Excel 2016 vs 2007

Office 2016

Novice

Join Date: Jul 2016

Posts: 2

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:22 PM.