Software

Ask something
Question Locked

Excel Pivot auto update

0 helpful
2 replies

by mickydm

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have excel pivot reports that I have created via the odc and would like them to auto update when I add data to my access database, I want them to update without having to open excel or right click refresh. Is this possible???

Thank you.

2 replies

by choppit

You can't update the pivot reports without opening Excel, but you could automatically refresh them with a few lines of VBA.

Possibly the easiest way to do this is start recording a macro, perform a manual refresh, stop macro. You can then paste the generated VBA into the relevant workbook event.

This discussion is closed to new replies.