From https://ask.libreoffice.org/en/question/80419/saving-xlsx-file-causes-corruption/ When saving external references, for sheet names that have to be quoted the file ID is prepended but Excel expects it within the quoted sheet name, the result is [1]'BLT Use Only'!$B$1:$B$32 instead of '[1]BLT Use Only'!$B$1:$B$32. This makes Excel complain about corrupted data and when "repairing" it discards the formula expression.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=02af87fdd76bc94fb51aeb160c74d6f719c42c63 Resolves: tdf#103531 OOXML: write external file ID within quoted sheet names It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/30324 for 5-2
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=40241c2aec0e88cbb51b802bda2db458e14f792f sc: OOXML: range with file ID within quoted sheet name, tdf#103531 related It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=56d61fdfabe600cfba50d684df38701248df796f&h=libreoffice-5-2 Resolves: tdf#103531 OOXML: write external file ID within quoted sheet names It will be available in 5.2.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Sample on Dropbox isn't available anymore, clearing URL field.