ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problem during load (https://www.excelbanter.com/excel-programming/341902-problem-during-load.html)

[email protected]

Problem during load
 
I would like to be able to set the Print_Titles to include a header on
each page. I have seen a lot of samples online, however I keep getting
a 'Problem during load' error when I attempt to open a new spreadsheet
I have generated via my web application.

Once I save the file in excel, it will open without the error. I have
even copied the code form the 'GOOD' sheet into one that has a problem,
and it doesn't seem to help.

here's the ExcelName tag I am using:

<x:ExcelName
<x:NamePrint_Titles</x:Name
<x:SheetIndex1</x:SheetIndex
<x:Formula=QF!$1:$11/x:Formula
</x:ExcelName


I have checked and rechecked and even copied from a good sheet, but the
only way I was able to get it to work was to copy the ENTIRE good
sheet!

Does anyone have any ideas on what I might do to get this working?
There seem to be a lot of people asking this question, but no answers.

I am writing a C#.NET web application and have made a lot of progress
on formatting the spreadsheet, but this one has me stumped!

Once I click OK on the error message, I am able to access the
functionality, but the error message is unacceptable to my customer.

TIA

Mark



All times are GMT +1. The time now is 08:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com