Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hpyerlinks updating to HTTP on publish
I have a company intranet that tracks our Drawing Files and CAD files. I use
excel to publish an index to existing webpage. This works wonderfully in that I can use excel functionality then hit save and all the drawing indexes are automatically saved. The picture files (TIF or PDF) work, but when you click on the CAD file it opens up an error page. When I try the links from the excel file they work like I want them too. It is just after the excel file is published that they start to give me errors. AutoCAD seems to have trouble open from an HTTP address. Is there a way to keep Excel from updating the hyperlinks to HTTP? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hpyerlinks updating to HTTP on publish
Incase anyone has the same problem there is a work around for this problem.
Under the insert menu select function, then select hyperlink. In this menu insert the file path. Example would be =HYPERLINK("file://address & file name.dwg") Excel does not update to HTTP when saving as a webpage. "Shayne" wrote: I have a company intranet that tracks our Drawing Files and CAD files. I use excel to publish an index to existing webpage. This works wonderfully in that I can use excel functionality then hit save and all the drawing indexes are automatically saved. The picture files (TIF or PDF) work, but when you click on the CAD file it opens up an error page. When I try the links from the excel file they work like I want them too. It is just after the excel file is published that they start to give me errors. AutoCAD seems to have trouble open from an HTTP address. Is there a way to keep Excel from updating the hyperlinks to HTTP? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you lock a jpg on a spreadsheet that you publish to web? | Excel Discussion (Misc queries) | |||
Excel Not Updating | Excel Discussion (Misc queries) | |||
publish to web | New Users to Excel | |||
How? publish many sheets in workbook??? | Excel Discussion (Misc queries) | |||
When updating a worksheet, how do I create a link updating the sa. | Excel Worksheet Functions |