• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 182
  • Last Modified:

Excel to HTML

Using Excel 97 on Win NT 4.0 Workstation.
Why is it that when I save a spreadsheet as HTML, the HTML document contains duplicate text?  Its a small and simple office directory that takes up one page in hardcopy.  The HTML document is exactly right except the text is repeated so it looks like two identical pages,  one following the other in the Browser (IE 5).  I can edit out the repeated text in the source code, but I shouldn't have too.
1 Solution
I created an HTML table based on a Excel Spreadsheet using Excel 97 on NT 4.0 workstation with no duplication.

I created a new never existed until the conversion took place file.  The tabled included only those cells that I selected.  I then went back and re-created the table again only this time I didn't select the exact same rows as the first time.  I did have the same columns selected.  The result was 2 different ranges, that would give me nearly identical results and would not be easily discerned when looking at just the html table.

My guess is that you have 2 ranges that you are sending to the conversion process.

kevinkempfAuthor Commented:
That's exactly what happened.  There were a number of ranges identified and I thought that by selecting one of them, that was the range to be converted.  Must be another Microsoft feature.  Makes no sense, but your answer works!  Thanks.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now