"Problems during load"

  • Thread starter Thread starter Vincent
  • Start date Start date
V

Vincent

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:Name>Print_Titles</x:Name>
<x:SheetIndex>1</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.
 
Vincent

Long shot but Page_Titles is a sheet level name not a workbook level name,
so it may need qualifying

Sheet1!Print_Titles

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top