IE Slow to Display Spreadsheet

[Nathan Evans]

Hi,

I've published an Excel spreadsheet, it's 630 rows by 256 columns, when I
browse it using IE (through IIS HTTP server) the file appears to download
then the CPU uses 100%. I've found that by changing the object class id (in
the HTML code), refresh the IE screen, and then change it back and, refresh
IE, then the spreadsheet appears - refresh again and it doesn't display
again. I've tried updating to OWC 11 but still no good. Any ideas please??

 

[Alvin Bruney [MVP - ASP.NET]]

Couple things. are you up to date on IE patches?
you can also turn off events before the sheet loads and then turn them back
on after the sheet loads.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

 

[Nathan Evans]

Hi Alvin,

Yes, IE is up to date.
Please could you expand on turning on\off events - just a starter

Thanks

Couple things. are you up to date on IE patches?
you can also turn off events before the sheet loads and then turn them
back on after the sheet loads.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

Hi,

I've published an Excel spreadsheet, it's 630 rows by 256 columns, when I
browse it using IE (through IIS HTTP server) the file appears to download
then the CPU uses 100%. I've found that by changing the object class id
(in the HTML code), refresh the IE screen, and then change it back and,
refresh IE, then the spreadsheet appears - refresh again and it doesn't
display again. I've tried updating to OWC 11 but still no good. Any ideas
please??

 

[Nathan Evans]

To add to this, when I create a new published spreadsheet and then browse to
it the spreadsheet displays imediately, if I then refresh or reload that
page, by moving to another site and returning, forcing a complete refresh,
the page takes a very long time to load - can be several hours, with IE
hanging and using 100% CPU doing some processing whatever that is.
Does anyone know why this is happening and a way to stop the long time
delays

Hi Alvin,

Yes, IE is up to date.
Please could you expand on turning on\off events - just a starter

Thanks

Couple things. are you up to date on IE patches?
you can also turn off events before the sheet loads and then turn them
back on after the sheet loads.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

Hi,

I've published an Excel spreadsheet, it's 630 rows by 256 columns, when
I browse it using IE (through IIS HTTP server) the file appears to
download then the CPU uses 100%. I've found that by changing the object
class id (in the HTML code), refresh the IE screen, and then change it
back and, refresh IE, then the spreadsheet appears - refresh again and
it doesn't display again. I've tried updating to OWC 11 but still no
good. Any ideas please??

 

[Alvin Bruney [MVP - ASP.NET]]

in that case, the simple fix should be to write an unload procedure so that
when the page unloads or the user navigates away from the page (or posts),
the spreadsheet is cleared. I believe you may be experiencing excessive
viewstate. so roughly
unload(){sp1.ActiveSheets.Clear();} //roughly

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

To add to this, when I create a new published spreadsheet and then browse
to it the spreadsheet displays imediately, if I then refresh or reload
that page, by moving to another site and returning, forcing a complete
refresh, the page takes a very long time to load - can be several hours,
with IE hanging and using 100% CPU doing some processing whatever that is.
Does anyone know why this is happening and a way to stop the long time
delays

Hi Alvin,

Yes, IE is up to date.
Please could you expand on turning on\off events - just a starter

Thanks

Couple things. are you up to date on IE patches?
you can also turn off events before the sheet loads and then turn them
back on after the sheet loads.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
Hi,

I've published an Excel spreadsheet, it's 630 rows by 256 columns, when
I browse it using IE (through IIS HTTP server) the file appears to
download then the CPU uses 100%. I've found that by changing the object
class id (in the HTML code), refresh the IE screen, and then change it
back and, refresh IE, then the spreadsheet appears - refresh again and
it doesn't display again. I've tried updating to OWC 11 but still no
good. Any ideas please??

 

[Nathan Evans]

Could you give me an example of how to disable events before the sheet loads
please? Also, how can I disable viewstates in javascript?
Thanks

Couple things. are you up to date on IE patches?
you can also turn off events before the sheet loads and then turn them
back on after the sheet loads.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

Hi,

I've published an Excel spreadsheet, it's 630 rows by 256 columns, when I
browse it using IE (through IIS HTTP server) the file appears to download
then the CPU uses 100%. I've found that by changing the object class id
(in the HTML code), refresh the IE screen, and then change it back and,
refresh IE, then the spreadsheet appears - refresh again and it doesn't
display again. I've tried updating to OWC 11 but still no good. Any ideas
please??

 

[Alvin Bruney [MVP - ASP.NET]]

Off the top of my head i think it is something simple like
document.all.sp1.EnableEvents = false;

you can't disable the viewstate of the control, and disabling the viewstate
of the page won't affect the control since it is part of the activeX
control. what i was suggesting was writing a routine to clear the contents
of the spreadsheet when the page is unloaded.


Here is more literature on the topic from the black book


.. Turn off undo events

The spreadsheet contains a bug that causes the stack to overflow

when loading large quantities of data. The work-around works well if

no events are monitored during the load process. Otherwise, you

will need to reduce the quantity of loaded data. This problem has

not been resolved in version 11. p 332.





--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

Could you give me an example of how to disable events before the sheet
loads please? Also, how can I disable viewstates in javascript?
Thanks

Couple things. are you up to date on IE patches?
you can also turn off events before the sheet loads and then turn them
back on after the sheet loads.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

Hi,

I've published an Excel spreadsheet, it's 630 rows by 256 columns, when
I browse it using IE (through IIS HTTP server) the file appears to
download then the CPU uses 100%. I've found that by changing the object
class id (in the HTML code), refresh the IE screen, and then change it
back and, refresh IE, then the spreadsheet appears - refresh again and
it doesn't display again. I've tried updating to OWC 11 but still no
good. Any ideas please??