Problem with Excel Binary format (XLSB) in Excel 2013

[exl]

Facing problem with XLSB format when working with Excel 2013 and sharing it with others. The original file was created in Excel 2007. The file works normally with Excel 2013, but when I share it with other Excel 2007 users, it gives the following errors:

When the user recovers the document, the following message appears:

The recovered document loses all formatting and alignments, but no loss of data. Also, there were no new features of Excel 2013 added to the particular document.

There is a workaround solution which I discovered, when I share the document in XLSX format (which bloats the file size and increases its size by 150%) and share it with other Excel 2007 users, it works normally with all features intact. Thereafter, if the file is saved in XLSB format from Excel 2007, it works perfectly in other machines.

Is there some inherent bug in Excel 2013 with respect to XLSB files. I don't want to lose working in XLSB files. Any help would be appreciated

 

[jkpieterse]

What -exactly- do you mean by sharing?
The shared workbook feature?
Using that feature is asking for trouble, especially when mixed Office versions are at play.

 

[exl]

What -exactly- do you mean by sharing?
The shared workbook feature?
Using that feature is asking for trouble, especially when mixed Office versions are at play.

Sharing means, sending the file by email.

 

[jkpieterse]

This certainly sounds like you hit some (unkown) bug in 2013.
If you are able to share the file with us (or a sanitized version which does trigger the problem in 2013) then I can report the bug.

 

[exl]

This certainly sounds like you hit some (unkown) bug in 2013.
If you are able to share the file with us (or a sanitized version which does trigger the problem in 2013) then I can report the bug.

There is no problem when you access the file on 2013, but once you have worked on that file and send it to somebody (Excel 2007), that is when the bug hits.

 

[RoryA]

Looking at the screenshot, it would appear to be an issue with one (or more) of the styles in the workbook.

 

[exl]

Looking at the screenshot, it would appear to be an issue with one (or more) of the styles in the workbook.

This workbook, consists of 11 sheets, with lots of conditional formatting, combo boxes etc.

 

[exl]

Any solutions guys

 

[jkpieterse]

Can't you share the file? YOu can probably empty all cells (control+a, hit del) for all sheets before posting.
Do this in 2007 and test whether it causes havoc in 2013. If so, please post it here.

 

[exl]

Can't you share the file? YOu can probably empty all cells (control+a, hit del) for all sheets before posting.
Do this in 2007 and test whether it causes havoc in 2013. If so, please post it here.

Jan,

As per your instructions, I have deleted all the data from my file, but the problem still exists. I have uploaded the file, so that you can have a look.

Here is the link Download BinaryWorkbook.xlsb