Make sure all your data is in Named Tables. To follow using our example below, download How to Create a PivotTable from Multiple Sheets.xlsx Images in this article were taken using Excel 2013 on the Windows 7 OS. The steps below will demonstrate how to create PivotTables using multiple sheets as a source of data and will apply only to Excel 2013 or later. But what can you do when the data you want to use is in separate tables in multiple sheets across your workbook?Įxcel 2013 introduced a method – called the Data Model – that lets you assign relationships between tables and create PivotTables across multiple sheets. Once you become a PivotTable fan, you will start to see lots of uses for this powerful analysis tool.
By Tepring Crocker Categories: Excel®, PivotTables Tags: Excel, PivotTable Multiple Sheets
0 kommentar(er)
