Enable seamless integration with Excel objects
In light of the items requesting return of Pivot*** objects (https://access.uservoice.com/forums/319956-access-desktop-application/suggestions/10284183-add-pivot-charts-back-to-access) being rejected, I want to suggest an alternative that I hope is much simpler to implement and would bring better experience:
Ability to seamlessly embed Excel objects, be they tables, charts, pivotcharts, pivottables, directly inside Access.
This already exists but it is very awkward, outdated, and includes unwanted things (e.g. Excel's chrome, the spreadsheet itself and so forth). This solution should allow us to define an Excel object using Access data and show it as if it was just a normal Access control. It should allow us to control whether users can interact with it or not, whether they can use Excel's chrome or not and so forth.
In fact, if this was extended to entire Office, that would be a major selling point for Access as it has been long used as the glue of the Office.
Thanks for suggesting and supporting this idea.
The team has reviewed and will take into consideration when planning future Access features and capabilities.
This item will be closed for voting, but you can add comments to show your support and share ideas.
Mark Woodhead commented
With any major change that MS provides in Access, will there be the all-important upgrade/conversion of 2007 pivot charts to the new version?? Without a conversion process there will be lot of work for the developer in upgrading important applications.
Justin Patterson commented
I hate Access charts in Access 2016.
Alan Cossey commented
At the UK Access User Group yesterday we had an interesting session on using Automation to create an Excel chart, exporting the chart to a .gif file and then using that as the source of an image control in an Access form, all from within Access. It isn't interactive out of the box, but quality-wise it is fine. It was one of those, "Oh, yeah" moments.
Peter Schmidt commented
Allowing Power BI embedded dashboards would probably achieve this and a whole lot more, especially if you can drill down and through to underlying records along the lines of what you can do with Dynamics 365
Alan Cossey commented
Wot Adrian said.
B. Clothier commented
Gilad, keep in the mind that the item is meant to address gaps in visual reporting; not merely just pivottable but also pivotchart and charting, all which are very outdated, awkward and hard to use in Access.
It is certainly possible to do what you describe. However, one notable feature that a pivottable has that can't be easily replicated in such thing is the multiple "column headers". A crosstab query permits only one column header whereas you can have more than one with a pivottable. Also, keep in mind not all merely produce static report - pivottable are objects users can interact, customize the rows/columns and apply additional filters to drill down as they want.
The way I see it, it's far more effective use of Microsoft's use products that already does those things extremely well than to invent their own wheels to use within Access.
Steve Schapel commented
Great idea, I would absolutely make use of a feature like that. Thanks Ben.
Adrian Bell (MVP) commented
If I only had any votes spare then I'd certainly drop three here.
[Deleted User] commented
Excel's charting far exceeds anything in Access, and is much easier to work with. This is a brilliant suggestion Ben!