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?
[Solved] Pivot Tables not Refreshing on Opening
-
- Posts: 5
- Joined: Tue Jul 11, 2017 7:32 pm
[Solved] Pivot Tables not Refreshing on Opening
Last edited by shanebelrose on Wed Oct 17, 2018 8:16 pm, edited 1 time in total.
Windows 7 Professional Open Office 4.1.5
Windows Server 2012 R2 Open Office 4.1.0
There will be Questions
Windows Server 2012 R2 Open Office 4.1.0
There will be Questions
Re: Pivot Tables not Refreshing on Opening
No, they don't and never did.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 5
- Joined: Tue Jul 11, 2017 7:32 pm
Re: [Solved] Pivot Tables not Refreshing on Opening
Okay. Will do up as a Google Sheet.
Thank You.
It may be something to look at some time.
Thank You.
It may be something to look at some time.
Windows 7 Professional Open Office 4.1.5
Windows Server 2012 R2 Open Office 4.1.0
There will be Questions
Windows Server 2012 R2 Open Office 4.1.0
There will be Questions
Re: [Solved] Pivot Tables not Refreshing on Opening
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
From your document call Tools>Customize... tab:Events
assign the "document open" event to the macro.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 5
- Joined: Tue Jul 11, 2017 7:32 pm
Re: [Solved] Pivot Tables not Refreshing on Opening
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.
All Macros are disabled by our IT Dept. They are very efficient at what they do. Otherwise I would be jumping at this.
Windows 7 Professional Open Office 4.1.5
Windows Server 2012 R2 Open Office 4.1.0
There will be Questions
Windows Server 2012 R2 Open Office 4.1.0
There will be Questions
Re: [Solved] Pivot Tables not Refreshing on Opening
I doubt that they disabled all kinds of macros, public ones, embedded ones, written in Basic, in Python, in Java,...
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 5
- Joined: Tue Jul 11, 2017 7:32 pm
Re: [Solved] Pivot Tables not Refreshing on Opening
You are talking well beyond me.
I will try it and see what happens
Thank You
I will try it and see what happens
Thank You
Windows 7 Professional Open Office 4.1.5
Windows Server 2012 R2 Open Office 4.1.0
There will be Questions
Windows Server 2012 R2 Open Office 4.1.0
There will be Questions
Re: [Solved] Pivot Tables not Refreshing on Opening
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.
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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice