Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to stop pivot tables and conditional formatting from being deleted on file open

I have an Excel workbook that some of my users open with LibreOffice. This workbook contains pivot tables and conditional formatting. When LibreOffice opens this file it immediately deletes the pivot tables and the conditional formatting. Am I honestly the first person ever to encounter this? I can find no documentation that describes this compatability problem. Conditional formatting and pivot tables are not that sophisticated, at least not in the way that I am using them. What am I missing?