Dec 6, 2006 #1 visor IS-IT--Management Nov 5, 2002 26 HK Is there any way I can export pivot table's data to excel spreadsheet?
Dec 7, 2006 #2 mikej336 MIS Feb 10, 2005 164 US What are you exporting it from? Uncle Mike Upvote 0 Downvote
Dec 18, 2006 Thread starter #3 visor IS-IT--Management Nov 5, 2002 26 HK The pivot table is in Excel. The problem is I just have the table but not source data. I want to get the source data back from the pivot table. Upvote 0 Downvote
The pivot table is in Excel. The problem is I just have the table but not source data. I want to get the source data back from the pivot table.
Dec 19, 2006 #4 S SkipVought Programmer Dec 4, 2001 47,492 US Hi, In the PT activate the Wizard and hit the BACK button to get to the Data Source Window. Skip, [red][/red] Upvote 0 Downvote
Hi, In the PT activate the Wizard and hit the BACK button to get to the Data Source Window. Skip, [red][/red]