Hi I have uploaded the excel sheet on my sharepoint site.it is opening in a webpart. I have some hyperlinks columns in my sheet. But when i trying to access the hyperlink it is not navigate. why ? In my excel sheet whet it is opening in MS office it is working fine.
A:
If you are talking about Excel Web Access (displaying your Excel as a web page) AFAIK it does not support (it does not render) links.
Toni Frankola
2009-10-31 18:25:26
A:
Did you try holding down the control (ctrl) key when you click on the hyperlinks?
UJ
2009-11-01 02:19:13
It's a sharepoint website. it doesn't actually matter if you hold the control key. This would work in a doc or xls file but not in a web part in sharepoint
GxG
2010-09-22 09:32:41
A:
On your list page do the following:
- Click on settings -> list settings
- Click create column
- Change type to Hyperlink or Picture -> OK
- Open your excel file and copy the links to the new column.
I think this should work but it is untested.
Mitchell Skurnik
2009-11-02 08:31:19
If this or another posts answers your question, please mark it as "answered"
Mitchell Skurnik
2009-11-16 15:15:29
A:
Some of the things that you should check out in the control pane of the web part are if the checkboxes for Hyperlinks and Navigation are checked.
But, unfortunately, this did not solve my problem.
Another thing you could do is, in Excel go to Options and under General tab click Web Options and on the Files tab uncheck the "Update links on save".
Unfortunately this did not solve my problem either.
GxG
2010-09-22 09:36:46