Karen has attended:
Excel Pivot Tables course
Pivot tables and link to access database
In the 2003 version, once a pivot table had been created in Excel, it was possible to go directly back to the access database table query to adjust the fields etc. How is this done in the 2013 version?
RE: pivot tables and link to access database
Hi Karen,
Thank you for the forum question.
You can still amend the connection to an Access DataBase.
You will need to create the connection using MS Query. Go to the Data tab on the ribbon click From Other Sources and click From Microsoft Query. This will open up a connection wizard. Select MS Access Database* to the left and click OK.
In the Select Database dialog box navigate to the database and click OK. In the Query Wizard - Choose Columns dialog box select the columns you want to use in your PivotTable. After you have selected to columns click next. In the Filter Data dialog box you can filter the data. Click next. In the Sort Order dialog box you can sort the data. Click Next.
Click Next in the Finish dialog box.
In the Import Data dialog box select you want to create a PivotTable.
If you want to amend the database query click Connections in the Connections group on the Data tab. Select Query from MS Access Database and click Properties. In the Connection Properties dialog box click on the Definition tab. Click Edit Query bottom left and you will be back in the MS Query.
I hope this has answered your question.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
