Giving permissions in Excel 2010
  I've created a worksheet, that I want others on our network to use.  As soon as I click on "Share", I lose the hyperlink capability?  Is there a way I can allow others to use the worksheet and still be able to create hyperlinks?
August 25th, 2015 6:21pm

Hi PC_confused,

You can use "HYPERLINK" formula in a shared Workbook to get your result.

=hyperlink(link_location, [friendly_name])

Make sure to place the link_location and friendly_name in quotes (" ").

For example: =hyperlink("http://www.microsoft.com/en-us/","Microsoft") and you will get the result as shown in the following figure.

About the formula syntax and usage of the HYPERLINK function in Microsoft Excel, please refer to this article:
https://support.office.com/en-us/article/HYPERLINK-function-333c7ce6-c5ae-4164-9c47-7de9b76f577f?CorrelationId=9edc9aca-e5cb-4095-a084-35c1da721c0e&ui=en-US&rs=en-US&ad=US

Hope it's helpful.

Regards,

Emi Zhang
TechNet Community Su

Free Windows Admin Tool Kit Click here and download it now
August 26th, 2015 4:03am

 Emi Zhang, thank you for your speedy reply.  I can almost understand what you showed, but I can't get it to work on my PC.  Would this "Function Command" take the place of the grayed out Hyperlink option, if I right click on a cell? 

An example:  I would like to link "Folder A" to a sub-folder called "Fishing" in "Folder B", would I click on cell A1 in "Folder A", enter the function:  =hyperlink("http://www.folder b/","fishing"), should that link cell A1 to "Folder 1" in "Folder B"? 

  I'm missing something because I can't get that to work.  I have noticed that if I right click on cell A1 in Folder A and use that hyperlink function and then hold the cursor on cell A1, I get the following path displayed:

=HYPERLINK("file:///C:users\user\desktop\folder B\fishing")    --Notice the three back slashes and the four forward slashes --

it will take me to the fishing folder.  If I try to type your hyperlink example, using the http address and the back slashes instead of the forward slashes, I get a "Can not open the specified file" message?

As you should be able to tell from my attempted question, I am confused...

August 26th, 2015 1:06pm

Hi PC_confused,

Example            

Result            

=HYPERLINK("http://example.microsoft.com/report/budget report.xlsx", "Click for report")

Opens a workbook saved at http://example.microsoft.com/report. The cell displays "Click for report" as its jump text.

=HYPERLINK("[http://example.microsoft.com/report/budget report.xlsx]Annual!F10", D1)

Creates a hyperlink to cell F10 on the Annual worksheet in the workbook saved at http://example.microsoft.com/report. The cell on the worksheet that contains the hyperlink displays the contents of cell D1 as its jump text.

=HYPERLINK("[http://example.microsoft.com/report/budget report.xlsx]'First Quarter'!DeptTotal", "Click to see First Quarter Department Total")

Creates a hyperlink to the range named DeptTotal on the First Quarter worksheet in the workbook saved at http://example.microsoft.com/report. The cell on the worksheet that contains the hyperlink displays "Click to see First Quarter Department Total" as its jump text.

=HYPERLINK("http://example.microsoft.com/Annual Report.docx]QrtlyProfits", "Quarterly Profit Report")

To create a hyperlink to a specific location in a Word file, you use a bookmark to define the location you want to jump to in the file. This example creates a hyperlink to the bookmark QrtlyProfits in the file Annual Report.doc saved at http://example.microsoft.com.

=HYPERLINK("\\FINANCE\Statements\1stqtr.xlsx", D5)

Displays the contents of cell D5 as the jump text in the cell and opens the workbook saved on the FINANCE server in the Statements share. This example uses a UNC path.

=HYPERLINK("D:\FINANCE\1stqtr.xlsx", H10)

Opens the workbook 1stqtr.xlsx that is stored in the Finance directory on drive D, and displays the numeric value that is stored in cell H10.

=HYPERLINK("[C:\My Documents\Mybook.xlsx]Totals")

Creates a hyperlink to the Totals area in another (external) workbook, Mybook.xlsx.

=HYPERLINK("[Budget.xlsx]E56", E56)

To jump to a different sheet in the same workbook, include the name of the sheet, followed by an exclamation point (!), in the link. In the previous example, to create a link to cell E56 on the September sheet, include September! in the link.

=HYPERLINK($Z$1)

To quickly update all formulas in a worksheet that use a HYPERLINK function with the same arguments, you can place the link target in another cell on the same or another worksheet, and then use an absolute reference to that cell as the link_location in the HYPERLINK formulas. Changes that you make to the link target are immediately reflected in the HYPERLINK formulas.

I suppose this list answered your doubts clearly.

Regards,

Emi Zhang
TechNet Community Su

Free Windows Admin Tool Kit Click here and download it now
September 1st, 2015 5:17am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics