Results 1 to 14 of 14
  1. #1
    Lounger
    Join Date
    Feb 2002
    Location
    Surrey, England
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cells overwriting when saved as Web page (2000 SR-1)

    If I save a worksheet as a Web page and view it in a browser offline everything looks fine. However, when I upload it to the WWW server (Geocities, if it's relevant) and view it online one row on the sheet is always overwritten by the one immediately below it making both lines unreadable. I've tried editing, resaving, uploading new copies, copying and pasting but can't get it sorted. It happens on more than worksheet but not necessarily on the same rows ... any ideas. Am I missing something obvious? <img src=/S/surrender.gif border=0 alt=surrender width=31 height=23>

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Cells overwriting when saved as Web page (2000 SR-1)

    Can you attach your workbook (the .xls) to a reply to this post and I'll try to upload it to my Geocities account tomorrow. Thanks! --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    Lounger
    Join Date
    Feb 2002
    Location
    Surrey, England
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cells overwriting when saved as Web page (2000 SR-1)

    OK - ta for the swift response.
    Attached Files Attached Files

  4. #4
    Lounger
    Join Date
    Feb 2002
    Location
    Surrey, England
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cells overwriting when saved as Web page (2000 SR-1)

    Hmmm ... just clicked on the attachment to check it worked and it looks fine although when I look at the same copy on my Geocities account line 21 overwrites line 20.

  5. #5
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Cells overwriting when saved as Web page (2000 SR-1)

    Well, I got the same results ses, http://www.geocities.com/mesammyb/football.html, but it has nothing to do with the upload or Geocities, it happens when you save as html, see attached html document (zipped to overcome lounge restrictions). Need to think some more, but probably the small font. --Sam
    Attached Files Attached Files
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  6. #6
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cells overwriting when saved as Web page (2000 SR-1)

    I can't see an error on your page - but I do get a handful of run-time errors.

    Do you see an error here? - this was Save-As-WebPage using Excel XP, though.

    Or am I missing something obvious?
    Attached Images Attached Images
    • File Type: gif x.gif (3.3 KB, 0 views)

  7. #7
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Cells overwriting when saved as Web page (2000 SR-1)

    It was the small font. I changed everything in the schedule to 8 point and the alignment to wrap and uploaded to http://www.geocities.com/mesammyb/football8.xls. If you save the attached worksheet as html, it should work.

    However, if you just upload your original football.xls file, it works fine, http://www.geocities.com/mesammyb/football.xls
    Attached Files Attached Files
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  8. #8
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Cells overwriting when saved as Web page (2000 SR-1)

    No run-time error on either page. Both yours and mine are messed up (attached). I'm running Win2K and IE 6.0. But, Netscape 6 shows both of them beautifully without any errors.
    Attached Images Attached Images
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  9. #9
    Lounger
    Join Date
    Feb 2002
    Location
    Surrey, England
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cells overwriting when saved as Web page (2000 SR-1)

    Nice one, Sam. S'been doing my head in for weeks. Thanks for your time. <img src=/S/salute.gif border=0 alt=salute width=15 height=20>

  10. #10
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cells overwriting when saved as Web page (2000 SR-1)

    No problems with Win2K and IE5 here :-)


    Peter

  11. #11
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Cells overwriting when saved as Web page (2000 SR-1)

    Loafer, what browser, version and OS are you using? Looks like it must be an IE 6 problem.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  12. #12
    Lounger
    Join Date
    Feb 2002
    Location
    Surrey, England
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cells overwriting when saved as Web page (2000 SR-1)

    I'm using WinXP Pro and AOL 6 (which I think uses a cannibalised version of IE) but when I view the page using IE6 I get the same error but in a different place on the page. I tried changing the font size to 8 but it hasn't helped. Like you say, browser problem.

  13. #13
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cells overwriting when saved as Web page (2000 SR-1)

    Using W98 and IE6 at home.
    First opening had the fault, I changed the font size of the viewer and that cured it. but after that it opened ok regardless of the font setting!

    Maybe something to do with the font it is coded with?

  14. #14
    Lounger
    Join Date
    Feb 2002
    Location
    Surrey, England
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cells overwriting when saved as Web page (2000 SR-1)

    Just tried your suggestion myself. Went to "View" and "Text Size" in IE6, changed the size to something else and it displays fine (even though the text size doesn't actually change no matter which option I pick!).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •