Named Range corrupts workbook

Jan 21, 2009 at 9:43 PM
When I have a defined name range as shown below, when I open and save the workbook in Excel2007 format, the named range is corrupted and a warning message apears when trying to open the results.  I unzipped the xlsx file before and after and found that the named range changes.  Originally it starts off as Sheet1!$A$1:$A$7,Sheet1!$B$1:$B$7,Sheet1!$C$1:$C$7 and after saving it changes to Sheet1'!$A$1:$A$7:B7,Sheet1!C1:C7 . 

 <definedName name="Test"localSheetId="0">'Sheet1'!$A$1:$A$7:B7,Sheet1!C1:C7</definedName><o:p></o:p>

<o:p> <definedNamename="Test">Sheet1!$A$1:$A$7,Sheet1!$B$1:$B$7,Sheet1!$C$1:$C$7</definedName></o:p>

Jan 22, 2009 at 4:13 AM
We need to discuss this. Copied to work item #9001: