Analyze data?!?!

[Ilovexfiles]

Since Access 2013 cannot do Pivot Table, is it possible to automate it with Excel?

If I link Access to an Excel Workgroup that has a dashboard for example, will this work?

I already know I can export each time to analyze, but I am wondering if there is an easier more efficient way ?

Thanks

 

[CJ_London]

would using a crosstab query work for you? For multiple heading groups you create multiple crosstabs which you then link together in a final query.

Otherwise, so far as I am aware, the only option is to use Excel.

Never tried it, but you can use code to create an excel instance in Access, populate Excel with the data then run the pivot. You then should be able to scan through the resulting pivot table to populate a temporary table in Access.

Otherwise, if you already have an Excel dashboard, you can link to or import the data from access and just do the pivot in Excel.

 

[NauticalGent]

Although I didn't use the pivot tables or charts, I do know that a lot of Excel users tried Access for this reason...and now it is gone. I sometimes wonder if MS is trying to kill Access.

 

[isladogs]

On the MS Access suggestions forum there were hints that pivot tables may be restored due to user feedback. Having said that, MS previously indicated the opposite.

If it matters to you, go there and add your votes.

https://access.uservoice.com/forums/319956-access-desktop-application/suggestions/18626704-please-bring-back-dynamic-charts-and-pivot-tables

 

[NauticalGent]

I did that for the SharePoint services, I will do the same for this. Thanks for the reminder...