Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Inserting a hyperlink with "Data Filter" on, in Excel
I'm trying to insert a hyperlink into one of the cells but it's not letting
me. When I right click on the cell, the hyperlink option is greyed out and when I use the formula =hyperlink() it only inserts the text. I have a Data/Filter on, is that what's stopping me? |
#2
|
|||
|
|||
I don't think so.
I could insert a hyperlink in a filtered range via Insert|Hyperlink and =hyperlink(). Any chance that the worksheet is protected? Any chance that the worksheet is grouped with another worksheet -- look for [Group] in the title bar? Any chance that the workbook is shared -- look for [Shared] in the title bar? Do you mean that you see the formula when you use =hyperlink()? If yes, make sure that that cell is formatted as General--not text. Bamff wrote: I'm trying to insert a hyperlink into one of the cells but it's not letting me. When I right click on the cell, the hyperlink option is greyed out and when I use the formula =hyperlink() it only inserts the text. I have a Data/Filter on, is that what's stopping me? -- Dave Peterson |
#3
|
|||
|
|||
Yes the Workbook is shared, and yes the cells are set for general and not
text. Is it because the workbook is shared? It's set so that other people can work in the same file at the same time. "Dave Peterson" wrote: I don't think so. I could insert a hyperlink in a filtered range via Insert|Hyperlink and =hyperlink(). Any chance that the worksheet is protected? Any chance that the worksheet is grouped with another worksheet -- look for [Group] in the title bar? Any chance that the workbook is shared -- look for [Shared] in the title bar? Do you mean that you see the formula when you use =hyperlink()? If yes, make sure that that cell is formatted as General--not text. Bamff wrote: I'm trying to insert a hyperlink into one of the cells but it's not letting me. When I right click on the cell, the hyperlink option is greyed out and when I use the formula =hyperlink() it only inserts the text. I have a Data/Filter on, is that what's stopping me? -- Dave Peterson |
#4
|
|||
|
|||
If you look in Excel's help for "Features that are unavailable in shared
workbooks", you'll see a big old list. One of the items is: Insert or change hyperlinks Bamff wrote: Yes the Workbook is shared, and yes the cells are set for general and not text. Is it because the workbook is shared? It's set so that other people can work in the same file at the same time. "Dave Peterson" wrote: I don't think so. I could insert a hyperlink in a filtered range via Insert|Hyperlink and =hyperlink(). Any chance that the worksheet is protected? Any chance that the worksheet is grouped with another worksheet -- look for [Group] in the title bar? Any chance that the workbook is shared -- look for [Shared] in the title bar? Do you mean that you see the formula when you use =hyperlink()? If yes, make sure that that cell is formatted as General--not text. Bamff wrote: I'm trying to insert a hyperlink into one of the cells but it's not letting me. When I right click on the cell, the hyperlink option is greyed out and when I use the formula =hyperlink() it only inserts the text. I have a Data/Filter on, is that what's stopping me? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get a hyperlink to track cut and paste data? | Excel Discussion (Misc queries) | |||
How do I get a hyperlink to track data movement? | Excel Discussion (Misc queries) | |||
How do I get a hyperlink to track specific data in a worksheet? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Data Filter - Not all rows in spreadsheet will display in Autofilt | Excel Worksheet Functions |