I have an .xlsx file that opens in Excel. However, if I remove the single quotes around the sheet name (which does not contain spaces) in the defined names field in workbook.xml, Excel repairs the file by removing that defined name.
Can anyone tell the criteria when do we have to surround the sheetname with single quotes?
The files are present here : https://www.dropbox.com/sh/eziv9jlbpsppw83/AACwurdX_aOhbK4R06FRizd3a?dl=0
00007113-ENGLISH_original.xlsx - Opens in Mac Excel 2011
00007113-ENGLISH_exported.xlsx - Does not open (Repair dialog)
There seems not to be a general description.
But I can tell you why Excel surrounds the sheet name RC2ACQuotas with quotes in the reference 'RC2ACQuotas'!$A$1:$Q$213. It is because RC2 also is a cell reference in R1C1 notation. It means RowColumn2 = this row column 2.
This seems not to be consequent since Excel surrounds a sheet name A123 with quotes but A123Test not. But sheet names starting with a cell reference in R1C1 notation will always be surrounded.