I am trying to generate Excel worksheets using .Net. The worksheets
are actually HTML pages with Excel specific XML elements. Everything
works fine until I added these following code in the template I'm
generating:

<x:ExcelName
<x:NamePrint_Titles</x:Name
<x:SheetIndex1</x:SheetIndex
<x:Formula='Initiative Status Report'!$4:$5</x:Formula
</x:ExcelName

If I add these lines to my ASPX page, Excel will give me an error
message with the heading "Problems during load" and the message "Excel
Name". If I click "Ok", the file loads up fine and everything is
display. Can someone please tell me how to fix this problem? Thank
you very much.