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?
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.