Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Western NY, USA
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Saving as HTML (2003 SP2)

    We have folks who save files as HTML from excel. However, Excel kindly rewrites the links. If I type ../mypath/myfile.html, Excel converts it to a fully qualified path, i.e. http://myserver/mypath/myfile.html. What is even worse, not all of our folders are shared with thier folder name. Excel insists on using the share name and not the folder name in the link.

    Any ideas? Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Saving as HTML (2003 SP2)

    With the workbook open, select File | Properties.
    Set the Hyperlink Base property to the folder you want to use as 'root'. All new hyperlinks you add after that will be relative to this root (if possible, of course), and this will hold over in the conversion to HTML.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Western NY, USA
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving as HTML (2003 SP2)

    Thanks again! I used to be good on Excel, until I started learning it. Now I realize how much more there is to learn. ;-)

Posting Permissions

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