Links in an excel spreadsheet

[LouiseH24]

Hi there,

A user of ours has a number of spreadsheets that they link to other workbooks.

What we would like to find out are all the cases in a spreadsheet where a user has selected a cell and has pasted a link to this cell in other workbooks. I have tried using tools/options/view formulae but this only shows the links that have been pasted into the workbook, but not those which are pasted into other workbooks.

Is there any way of finding out where these links go to/from?

Thanks for your help.

Lou

[darknation144]

You right click on them and view where the hyperlink goes. I have no idea how would you tell if there is a linking going to a workbook I think that is impossible as it's just a static pointer.

[LouiseH24]

Thanks Darknation