| Thread | Last Post | Replies |
|
| hyperlinks in excel2002 won't save correctly | 25 Sep 2007 12:32 GMT | 4 |
I'm having problems keeping hyperlink paths when i save an excel file as html. The hyperlink works fine in excel: links to a pdf "file:///\\server\share\folder\file.pdf" but when saved as html it is just saved as "folder/file.pdf" I'm using the html on a webserver so need the
|
| When is =HYPERLINK() not a hyperlink? | 21 Sep 2007 05:47 GMT | 2 |
In Excel 2002, if I insert a hyperlink to, say, My.jpg using Insert / Hyperlink, I can launch the file in at least 3 ways: 1) Hovering over the link displays a tooltip, confirming Excel knows a hyperlink is there; and clicking it launches My.jpg. 2) The context
|
| about Offset function | 20 Sep 2007 01:51 GMT | 2 |
I got a model from a colleague. He used offset function but only with 3 inputs OFFSET(F171,$D$26,0). This is different from what explained in using offset, i.e. Offset(A1, 1, 2, 1, 1). Could anyone help me on understanding this? thanks!!
|
| Excel Paste Link not copying format | 14 Sep 2007 11:12 GMT | 1 |
I am using Excel 2007 and want to break up a large worksheet into many small sheets but retain the original data in one sheet. When pasting the coipied data as a link the copied data is inserted into the new worksheet but sans the original formating such as currency, number ...
|
| Link from Autoshape keeps changing | 03 Sep 2007 23:30 GMT | 2 |
I run Win2k and Excel 2K I have an autoshape that when slected hyperlinks to a html file. The problem I am having is that each time I open the file the hyperlink changes to one of my other "recent files" hyperlink. To overcome it I have to selct the
|