Excel 07 issue opening MHT format

J

Jia Xu

My code generates MHT content that we named as .xls file so it can be opened
in Excel. Some of the worksheets are set to be Hidden, which seems to making
some problem with Excel 07. The steps are following:

1) Open the file in Excel 07
2) Click "Save" in File menu
3) Close the file, reopen it again, there is no hidden sheet any more

This is a problem because I used the hidden sheet to hold the data port of a
chart. After the above steps, the chart is showing empty data.

This doesn't happen with Excel 2003, and if the worksheet is not hidden, we
don't have a problem.

Is this some bug of Excel 07?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top