OWC Hangs IE

[Nathan Evans]

I have an Excel spreadsheet which i'm publishing to a web site. The page
with the spreadsheet loads fine through IE6 but then if you try to refresh
or move to another web page IE uses 100% CPU and can take upto 30 mins
before it loads the new page - any ideas to solve this long delay??

 

[dextius]

window.onbeforeunload = function () {
cleardata( document.getElementById('Spreadsheet1') );
forceIECleanup();
}

Change "spreadsheet1" with whatever ID you have for your spreadsheet.

 

[dextius]

oops.. forgot to post cleardata

function cleardata(obj) {
obj.ScreenUpdating = false;
obj.ActiveSheet.Cells(1,1).Select();
obj.Sheets(1).UsedRange.Clear();
obj.ScreenUpdating = true;
obj = null;
}

 

[Nathan Evans]

Thanks for this works a treat!

Perhaps you can help with another very similar issue - this time, and i'm
not sure what has changed, but on the first visit to the page with the
published spreadsheet on it does the same, CPU 100% . If I open the file
locally, not through HTTP, it opens fine.