[Solved] Pivot Tables not Refreshing on Opening

[shanebelrose]

Good Day
Are Pivot tables suppose to refresh on opening the file? I believe this was happening at one point.
I have tried in windows 10, windows 7 pro and windows server 2012 R2

I have tried as .ods and as .xls

Is there something I am missing?

[Villeroy]

No, they don't and never did.

[shanebelrose]

Okay. Will do up as a Google Sheet.


Thank You.
It may be something to look at some time.

[Villeroy]

Code: Select all

Sub refresh_all_pivots()
for each sh in ThisComponent.getSheets()
  for each pv in sh.getDataPilotTables()
    pv.refresh()
  next
next
End Sub

Save the macro somewhere in Tools>Macros>Organize>Basic...
From your document call Tools>Customize... tab:Events
assign the "document open" event to the macro.

[shanebelrose]

Thank you Villeroy
All Macros are disabled by our IT Dept. They are very efficient at what they do. Otherwise I would be jumping at this.

[Villeroy]

I doubt that they disabled all kinds of macros, public ones, embedded ones, written in Basic, in Python, in Java,...

[shanebelrose]

You are talking well beyond me.
I will try it and see what happens
Thank You

[Villeroy]

Open a new Writer document.
Can you call menui:Tools>Macros>Organize>Basic...?
In container "OpenOffice Macros" I find a library "Gimmicks" and a module "AutoText". Can you run the "Main" routine? It generates a bunch of Writer tables.

Can you call menui:Tools>Macros>Organize>Python...?
In container "OpenOffice Macros" I find a library "HelloWorld" with a routine "HelloWorldPython". Can you run the "Main" routine? It appends "Hello World (in Python)" to the current Writer document.