I’ve been chasing around the internet for several hours now and it seems like it’s time to ask the experts here for advice.
I have a LO Calc document that contains several sheets. One of the sheets contains a pivot table. As the underlying data changes, the data in the pivot table changes, but, to see those changes, I need to refresh the pivot table. I’m quite capable of doing that myself, buy my user is not, so I’m looking for a way to cause the pivot table to refresh “automatically” when underlying data changes or in response to some other useful trigger.
I have looked for “auto-refresh” of a pivot table, and I’m pretty sure what I’ve learned is that that functionality is not currently available. Is that right?
Assuming the direct “auto-refresh” is not available, I created a macro that pushes the “refresh” button given the appropriate sheet is active and have attempted to tie it to various events in the sheet that contain the pivot table. If I open that sheet, select a cell in the pivot table, and run the macro, it works. But there doesn’t appear to be any event I can tie it to that reliably executes it when that event happens. I’ve tried “Activate Document”, “Deactivate Document”, right click, content changed, and various other events. Sometimes the recalculation happens and sometimes it does not.
I’ve looked for quite awhile for an answer to this second question with no joy either. There appears to be no event I can associate my macro with that would cause it to run.
I’m sure I’m doing something wrong, and I look forward to any advice from the experts.
Thanks in advance.