B
Bob
I am creating a worksheet from an html page. I'm grabbing
data from a database (not using ASP), and putting it in an
HTML table. I have the Content-Type set to
application/vnd.ms-excel and the Content-Disposition set
to attachment so the file will download. I have all the
formatting working as I need, but I am receiving an error
when I open the worksheet with Excel (2002).
"Problems during load: The follwing areas had errors
Excel Name"
The name in question comes from my print titles. The code
in question, comes from my html file, in an xml section
specifically for MS Office. Here is the snippet:
---Begin code snippet---
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
...
...
</x:ExcelWorkbook>
<x:ExcelName>
<x:Name>Print_Titles</x:Name>
<x:SheetIndex>1</x:SheetIndex>
<x:Formula>=BugTrackerStatus!$3:$3</x:Formula>
</x:ExcelName>
</xml><![endif]-->
---End of code snippet---
The code is used just to pre-set the row that will print
on each page (column headers). Every time the generated
worksheet is opened by Excel I receive the error message.
I click OK on the dialog box, the worksheet opens, and all
my formatting is correct icluding the print titles. The
worksheet prints just fine and I can see no problems.
So, what does the error mean? What can I do to eliminate
it? With certain users, telling them to bypass the error
dialog is like speaking a foreign language.
data from a database (not using ASP), and putting it in an
HTML table. I have the Content-Type set to
application/vnd.ms-excel and the Content-Disposition set
to attachment so the file will download. I have all the
formatting working as I need, but I am receiving an error
when I open the worksheet with Excel (2002).
"Problems during load: The follwing areas had errors
Excel Name"
The name in question comes from my print titles. The code
in question, comes from my html file, in an xml section
specifically for MS Office. Here is the snippet:
---Begin code snippet---
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
...
...
</x:ExcelWorkbook>
<x:ExcelName>
<x:Name>Print_Titles</x:Name>
<x:SheetIndex>1</x:SheetIndex>
<x:Formula>=BugTrackerStatus!$3:$3</x:Formula>
</x:ExcelName>
</xml><![endif]-->
---End of code snippet---
The code is used just to pre-set the row that will print
on each page (column headers). Every time the generated
worksheet is opened by Excel I receive the error message.
I click OK on the dialog box, the worksheet opens, and all
my formatting is correct icluding the print titles. The
worksheet prints just fine and I can see no problems.
So, what does the error mean? What can I do to eliminate
it? With certain users, telling them to bypass the error
dialog is like speaking a foreign language.