Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

On our solution (SP Foundation) we multiple lists with quite some lookup fields. Some of the lookup fields are user fields who link to the user info list, and we don't want that to happen.

enter image description here

Of course, we can limit the access of the (user info) list itself, but it's not a nice solution when the user clicks on the lookup field, and lands on a access denied page.

The question is: Is it possible to remove the link from the lookupfield? If yes, how?

Thanks in advance, Markus.

share|improve this question
add comment

2 Answers

up vote 4 down vote accepted

Your best bet would be to remove that field/column from the Public view and all other views where you dont want to see it.

If you still want to see the value, create a calculated column which extracts the value from the lookup column and displays that. use the =TEXT calculated column

Hope this helps.

share|improve this answer
Thanks for the quick answer, that'll work fine for me. :) –  Markus Schwalbe Jul 12 '11 at 8:14
Lookup Columns are not available in Calculated Columns –  theChrisKent Aug 30 '12 at 20:08
add comment

The previous answer is really not a solution it is just workaround. You best bet is not to remove field or create some calculated field o just use what SharePoint can give to you. First you should create xsl in mapped folder \14\TEMPLATE\LAYOUTS\XSL for example UsersInfoViewStyles.xsl and add content like in image bellow changing field internal name to you lookup field: enter image description here

Second step is to change XslLink to your created xsl file of view defined in schema.xml file like in image bellow: enter image description here

This will take off links from you lookup field in view. I hope this helps someone in the future.

share|improve this answer
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.