Joni, that was brilliant. Thank you

"joni_piter" wrote:

There is another way (from excel help!!):
To Deactivate several hyperlinks at once:
1. Type the number 1 in a blank cell, and right-click the cell.
2. Click Copy on the shortcut menu.
3. While pressing CTRL, select each hyperlink you want to deactivate.
4. Click Paste Special on the Edit menu.
5. Under Operation, click Multiply and then click OK.


"Tamsin" wrote:

i am currently having problems with hyperlinks. Is there a way to
permanently remove from a spreadsheet without having to go into each cell
individually (I have text in the cells)? I have been deleting them and they
keep reappearing - the hyperlinks are even appearing in new spreadsheets and
now seem to be embedded in other spreadsheets.

Any help would be much appreciated.
--
Tamsin