Excel'07 Binary file crashes if data validation refers to named range against Excel Table

Hi All,

I have a number of MS Excel workbooks which are uploaded into a SharePoint workflow solution. Some of these are large in size and exceed our companies single file size limit in SharePoint of 50mb. We've submitted a buiness case to increase the size but must continue as is for now (and must also manage risk by considering the request is denied). As a result, I've been converting xlsx & xlsm files to xlsb binary (as significantly reduces file size) which for the most part has not caused any issues, until now:

If the workbook contains the combination detailed below, the binary file will save ok and work as expected until you close and re-open, when you will be greeted with the standard "MS Office Excel has stopped working" error. So far this occurs 100% with no exceptions. The repair removes the table and deletes the "Refers To" code of the named range, but not the named range itself.

The combination is: MS Excel Table plus a Dynamic Named Range which refers to a column in the MS Excel Table plus Data Validation which refers to the Named Range

This can be replicated in 2 minutes in a new workbook (I've prepared and attached an xlsx file, with steps taken to build, simply continue from where you save as a binary).

The purpose of this topic is that I am trying to get a better understanding of the route cause and if there is a fix/patch etc. For anyone else who also has this problem, my tests so far confirm that it is the above combination that causes the crash on opening, however there are a number of workarounds by changing the above combination, one of which is to change the formula in the "Refers To" property of the named range so it refers to the worksheet instead of directly referencing the table (eg instead of "=Table1[Column1]", as per the attachment, try replacing with "=Sheet1!$A$2:INDEX(Sheet1!$A:$A,COUNTA(Sheet1!$A:$A))").

I hope the above is clear enough and the attachment helps to demonstrate, however I will gladly provide more information if requested and where possible.

Can anyone enlighten me as to the route cause and if there is a fix?

Many Thanks in advance.

Tooley