XL 2007 link to a photo file and "publish"
 

I've been able to save the worksheet as a webpage and then "publish"
it. It becomes a .mht format. When I upload it, it shows up just fine
in the browser (IE). However, the links are all relative to the local
directory. I want them to just have the filename, since I'm putting
the photos in the same remote directory as the worksheet mht file. So
far I've only thought of manually editing the mht source code to
remove the pathname, but there MUST be an easier way.