"Problems during load"

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.
 
N

Nick Hodge

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top