So I've found a wierd behavior with excel. I copy a set of cells with links in them over... suddenly there are links in blank cells on the brand new sheet. Also, if I cut paste another group of cells the links change on all of the previous cut cells.

Kinda a pain in the ass. The sheets are from the same version of excel, there are no macro's, no equations going on. It's a simple spread sheet.

So I need a solution... either fixing this alltogether or is there a way to remove all links in a spread sheet? The title of the link is the same as a link so that would be a matter of me going to the cell and hitting enter.

Thanks!

3/27/2007 8:18:38 AM

http://www.learningelectric.com

i hope this at least "maybe" helps you

3/27/2007 8:19:59 AM

http://www.techonthenet.com/excel/macros/delete_hl.php

Blam thanks! your site gave me the idea I needed.

3/27/2007 8:27:21 AM

you don't even need to do that. if it's from copy and paste, just paste special - values or values and number formats

alt+e - s - t or u

3/27/2007 9:12:18 AM

Cool idea, but I prefer the macro way since I can get everything over and then just run a single macro that does the job for me.

I've also noticed that when copy and pasting within the excel it does it too. Bug city.

3/27/2007 9:19:06 AM

oh, i thought you were just copying an entire sheet over, not individual cells or whatever

3/27/2007 10:10:34 AM

i'm glad i could help

3/27/2007 1:30:54 PM

Kinda on the same idea of simple shortcuts...

I have been using the ASAP Utilities plug-in and it's got a lot of these things in there.

http://www.asap-utilities.com/download-asap-utilities.php

3/27/2007 7:24:56 PM

you are copying the formulas right??? b/c ctl+c and ctl+x won't do that automatically

3/27/2007 9:38:10 PM