Web Publishing from Excel
 

Hi there.

I have spent the last few days designing a spreadsheet that I had planned on
publishing to the web (static data)...

Within the spreadsheet, I have a number of "series" and have made the series
names into links within Excel.

However, excel AUTOMATICALLY seems to be prefacing the filename (i.e.
s&p.htm) with the full path name where it is located on my harddrive (which
will not work once uploaded to the web). Is there any way to stop it from
doing this?

As well, I would like to specify the target of the <a href... to be a
different frame, as it currently opens in the same one that my data is
displayed in...I haven't found a way to do this in Excel either. Can anyone
help?

Thanks so much!

David