Before you can create a PivotTable, you’ll need some data. Let’s get some data from the Navision database. In Excel, open a blank workbook. You have several options for getting data from no of sources. Recall from my earlier post where we accessed data using web service in Excel.