We are using SharePoint to post and store word files for a new project we are working on. My boss has asked for a list of those posted thus far. I exported the list from Sharepoint to MS Excel and unlinked it but the file names still remain as hyperlinks and everytime we click on one it opens the MS Word file.
Can anyone tell me how to stop them being hyperlinks? I just need a plain old list at this point!
Please help!
Chosen Answer:
Here are two approaches you can use in Excel:
1) Select and copy the entire list range
2) Go to a new worksheet
3) Right click & select ‘paste special’
4) Paste values
5) The links should be gone. . . if not . . .
1) Select and copy the entire list range
2) Edit, Links, Break Link(s)
by: Neutered Pup
on: 6th November 08
