Is there any way to change a pivot table from an external source to a table within the workbook?
Is there any way to change a pivot table from an external source to a table within the workbook?
I haven't tried it since I don't have a pivot table built on an external source, but select a cell in the Pivot Table and then in Pivot Table Tools, select Analyze -> Change Data Source.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks