 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2006Keeping the hyperlink address hidden in a cell.
Good everning: Cells in my spreadsheet have numbers that are needed to identify file names. I need to link the file to the numbers. I used the hyperlink function, only to lose the number. The number is VERY important, I can't remember, won't have a clue, and other viewers of the spreadsheet will be unable to determine what file number it is. I want the number to show in the cell and the hyperlink function to be hidden like any other function on a spread sheet. Thank you very much. Roberta Woops. Does the hyperlink point to a different worksheet ? Maybe the hyperlink opens a new file which looks similar, but minus the number. Or perhaps, the hyperlink refers to another worksheet in the same workbook. Going forward try Tools>Options>Save>Make "local copy" of file. > Good everning: > [quoted text clipped - 10 lines] > > Roberta Thank you Jason: The cell contains a numeric value that I want to add a hyperlink to and still have the numeric value displayed. Right now if I insert a hyperlink from the insert menu, I get an error message, "The address of this site is not valid. Check the address and try again.". It may work for a moment, but when I close and save the file and reopen, I get the above error message. Then I used the hyperlink function and that's when I loose my numeric value and you only see the function. This is posted on our company intranet site and I would get a lot of calls, "where is my file, etc?" Roberta ****************************** >Woops. Does the hyperlink point to a different worksheet ? Maybe the >hyperlink opens a new file which looks similar, but minus the number. Or [quoted text clipped - 6 lines] >> >> Roberta I've never had any trouble when I used the =hyperlink() worksheet function: =hyperlink("file:////server/sharename/folder/filename.ext",12345) (where 12345 is the thing you want to see in the cell) Other people have said that if they change the hyperlink base (file|properties|summary tab) to something that is always available (C:\ for instance), it can help stop those links from changing. > Thank you Jason: > [quoted text clipped - 25 lines] > Message posted via OfficeKB.com > http://www.officekb.com/Uwe/Forums.aspx/excel-functions/200606/1  SignatureDave Peterson WHO'S THE MAN!!! ----- YOU ARE!!! --- Swee! Thank you, Dave!!!!!! >I've never had any trouble when I used the =hyperlink() worksheet function: > [quoted text clipped - 12 lines] >> >> >> >> Roberta Are you saying that it worked for you? <vbg> Which one did you use? > WHO'S THE MAN!!! ----- YOU ARE!!! --- Swee! Thank you, Dave!!!!!! > [quoted text clipped - 18 lines] > Message posted via OfficeKB.com > http://www.officekb.com/Uwe/Forums.aspx/excel-functions/200606/1 SignatureDave Peterson Yes Dave - the following did: =hyperlink ("path\filename","text") This lets my nurmeric field be displayed only in the cell. My fields start with "0" and that is why I had to use the "text " (012345) so the correct file name is seen by the viewer and not the hyperlink address. I did not have to use " " around the text, just like you have it in your example. But I needed the "0" to show. Thank you - ************************************************************ >Are you saying that it worked for you? <vbg> > [quoted text clipped - 5 lines] >> >> >> >> >> >> Roberta You could format that value: =hyperlink ("path\filename",text(a1,"0000000") to include the leading zeros. > Yes Dave - the following did: > [quoted text clipped - 22 lines] > -- > Message posted via http://www.officekb.com SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.