Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hi

With ToolsCustomizeEvents tab, you can assign a macro to the Open Document event:

Sub RefreshPilot
dim oSheet as object, oPilot as object

for each oSheet in thiscomponent.sheets
    for each oPilot in oSheet.DataPilotTables
        oPilot.refresh
    next oPilot
next oSheet
end sub

Of course, ToolsOptionsLibreOfficeSecurityMacros Security must be set to allow execution

Regards