Hi,

I have a user who is compiling a spreadsheet from various other spreadsheets
however when the user is pasting information from one into the other it is
creating hyperlinks in cells adjacent to the ones in which the data is being
pasted. If anyone has any ideas as to why and how to stop this from happening
it would be much appreciated as I cannot figure out what is going on. I have
added a macro to the sheet to remove all of the hyperlinks but after pasting
data in they are having to run again which is sometimes causing Excel to
crash.

Thanks in advance.

Paul