This is my first bug report, but I did not find any previous reports that were an exact match. [Please note that I am reporting this for Calc 5.x, but I also experienced the problem in Calc 4.x (latest version) before upgrading to see if that solved the problem.]

Here is my report:

Date of report: 2015.0827

Subject: "Open Excel Pivot Table in LO Calc causes Excel to crash."

Excel version: 2007 (12.0.6727.5000) SP3 MSO (12.0.6728.5000)

LibreOffice version: 5.0.0.5 (x64) Build ID: 1b1a90865e348b492231e1c451437d7a15bb262b

============START TEST 1===============

[Step 1]
  Create Excel Data and Pivot in new workbook. Save file in xlsx format.

[Step 2]
  Open workbook in LibreOffice Calc. Adjust column widths for content. Save file in xlsx format.

[Step 3]
  Open workbook in Excel.

[RESULT]
  Error shown below:


"Excel found unreadable content in 'Excel_LO_TEST_1.xlsx'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."

[Answered 'Yes']

"Excel was able to open the file by repairing or removing the unreadable content.

"Repaired Records: PivotTable report from /xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable cache)"

--------------------Start of Log Record---------------------
<?xml version="1.0" encoding="UTF-8" standalone="true"?>

-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

<logFileName>error040320_01.xml</logFileName>

<summary>Errors were detected in file 'C:\Users\Owner\LKJ-OtherFiles\Google Drive\Misc TESTS\Excel_LO_TEST\Excel_LO_TEST_1.xlsx'</summary>


-<repairedRecords summary="Following is a list of repairs:">

<repairedRecord>Repaired Records: PivotTable report from /xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable cache)</repairedRecord>

</repairedRecords>

</recoveryLog>
--------------------End of Log Record---------------------

[Step 4]
  Refreshed Pivot Table

[RESULT]
  Excel crashes, restarts, and lists recovered files.

[Step 5]
  Save Autosave file and original file (with changes made by Excel).

[Step 6]
  Open Autosave file and refresh pivot table.

[RESULT]
  Excel crashes without restart or recovery.

[Step 7]
  Open original file (with changes made by Excel) and refresh pivot table.

[RESULT]
  Excel crashes without restart or recovery.

============END TEST 1===============

============START TEST 2===============

[STEP 1]
  Make a copy of Excel workbook created in TEST 1 STEP 1.

[STEP 2]
  Open workbook with LibreOffice Calc. Make no changes. "Save as" in xlsx format and close file.

[STEP 3]
  Open workbook with Excel.

[RESULT]
  Same error as in TEST 1 STEP 3.

[STEP 4]
  Do not open log or select files to save. Instead, refresh pivot for selected file.

[RESULT]
  Same as TEST 1 STEP 6 and STEP 7.  
============END TEST 2===============