Excel 2003 Save as web

[MCW]

Background:

1- I created a workbook using the Excel 2000 (Office 2000 SP3 OS:Wi
2000).
2- The workbook contains several sheets which are used to displa
numerical data and charts.
3- The data is been collected/imported from .DAT files using VB/Macr
which also creates/add new sheets and charts. And finally saved a
Web.
4- Every thing works fine when using Excel 2000. And the created we
result are working beautifully.

Problem:

When jag try to use the same workbook in Excel 2003 (Office XP SP
OS:XP) the problem appears. The Excel seems at save as web for som
strange reason stop responding at 100% CPU.

I have been successfully eliminated the problem to the function “Sav
As Web”. Because every think works until the Excel starts saving th
result as .htm. I simply created a new Workbook in Excel 2003 and onl
added the macro used to create the file original file to this one an
removed the save as web command. The result was fine all data/chart wa
created correctly and I was able to save the document in .xls.

But when I tried to save the same file in .htm the problem appea
again. The web save process in Excel 2000 takes only few seconds but i
Excel 2003 it takes for ever and its never finish. The result is tha
only the htm file for the first 3 or 4 sheets and nothing more.


Clues:

1- The workbook contains up to 20 sheets with up to 2000 rows of data.
2- On each sheet a chart is been created to present the above mentione
data.
3- The document is easily save in Excel 2000 and 2003 as .xls. Th
problem appears only when the file is save as web in Excel 2003.
4- I have checked the macro/VB. The problem is the same when I try t
save the file manually.
5- No password is been used.
6- The original file was made in Excel 2000. But as I explained earlie
recreation of the workbook in Excel 2003 hade no effects.
7- The Excel 2003 starts creation of the web files, and it seems t
stop when it reaches the lager sheet with lager amount of data/Chart
But as I mentioned earlier the same workbook is been save by Excel 200
in five seconds.
8- .

Thanks for any help.

Kind regards MC

 

[Jim Rech]

It's going to be tough for someone to figure out the problem without your
workbook. In fact, it may be tough even with it. I couldn't find any MSKB
articles indicating there was a problem saving in HTML in Excel 2003 and I
had no problem doing so myself.

I guess in your position I'd try to find out what aspect of the workbook was
causing the problem and go from there. I'd do that by deleting individual
sheets and trying a Save. When a save works then I'd try deleting objects
or ranges within the sheet to narrow it down. This may or may not lead to a
solution or workaround.

 

[dmf415]

im having the exact same problem on one particular worksheet.
try opening the same page with ms word, it does the exact same thing
right?

what i try to do is goto the web page and choose "Edit with MS Excel"
There is a button on the IE toolbar that you can pull down and select
this.

I get 100% CPU for 3-4 minutes. After that, it drops down to normal
cpu usage and the file imports properly.

I have used office 2000 doing the same thing and it worked within a
few seconds.