Ask Your Question

Do VBA PivotTable commands work in LO VBA compatibility mode?

asked 2016-02-29 13:05:24 +0200

JerryS gravatar image

I am trying to convert an Excel spreadsheet to run under LO in VBA compatibility mode. Everything works except operations on PivotTable objects (e.g. RefreshTable), which fail with a runtime error 423 with no explanation. Is it possible to do operations on Excel PivotTable objects in VBA compatibility mode?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-02-29 14:32:42 +0200

karolus gravatar image

If you want to run every VBA-stuff nativly -- stay with M$-office -- otherwise throw away the useless VBA ( approximatly 95% ) and rewrite the usefull parts.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-02-29 13:05:24 +0200

Seen: 141 times

Last updated: Feb 29 '16