| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
For some reason, this solution didn't work for me, so I put together a formula that when used in conjunction with the HYPERLINK formula sidesteps the issue quite well.
=CONCATENATE(SUBSTITUTE(LEFT(CELL("filename"),FIND ("]",CELL("filename"))-1),"[",""),"#") Define the formula as DocLocation and specify hyperlinks as: =HYPERLINK(CONCAT(DocLocation, "Sheet2!A1"), "Go to Sheet 2") Emulating relative links like this isn't ideal, but it gets the job done if nothing else works, and doesn't rely on macros. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sharing Workbook on SharePoint by many users and Save on SharePo | Excel Discussion (Misc queries) | |||
| Excel links & SharePoint 3.0 (worked fine with SharePoint 2.0) | Excel Discussion (Misc queries) | |||
| Sharing a workbook in Sharepoint or another web-based doc mgmt sys | Excel Discussion (Misc queries) | |||
| How do I force a workbook to open in Excel from a Sharepoint libra | Excel Discussion (Misc queries) | |||
| SharePoint instead of Share Workbook? | Excel Discussion (Misc queries) | |||
Threaded Mode
