I'm looking to create a pivot using the data from a named table in a different excel file, is this possible? And I suppose i ought to add relatively easy to do since I'm not brilliant with excel.
I'm looking to create a pivot using the data from a named table in a different excel file, is this possible? And I suppose i ought to add relatively easy to do since I'm not brilliant with excel.
You could do that if the data in the other workbook is set up as a data connection.
Select Insert -> Pivot Table
Click on Use an external data source.
Click on Choose Connection
Click on Browse for More
Navigate to the workbook containing the table.
Navigate the sheet containing the data.
Click OK
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