What Happened to DELINKS?

[beadedbytes]

Long ago (Excel 1997?), I would use fairly regularly a DELINKS macro(?) to remove all the formulas from an Excel document. Is there something already predesigned that can be used in Excel 2003?

 

[macropod]

Hi beadedbytes,

How about Ctrl-A, Ctrl-C, then Edit|Paste Special|Values (you could speed this up by adding the 'Paste Values' icon to the 'Standard' toolbar). Alternatively, to convert just a subset of a worksheet's cells, copy that range then proceed with the pasting.


Cheers
[MS MVP - Word]

 

[beadedbytes]

Thanks, but I am looking for something that will go through multiple worksheets in one fell swoop like Delinks.

 

[macropod]

Hi beadedbytes,

In that case, you'll need to either find the original macro (it wouldn't have been an MS product) or recreate it. If you need help, I suggest posting in the Office vba forum (

http://www.tek-tips.com/threadminder.cfm?pid=707).

Cheers
[MS MVP - Word]

 

[GlennUK]

Hi beadedbytes,

in Excel 2003, in the Edit Links dialog ( menu command Edit/Links ), there is a button for "Break Link".

Will that do?

Cheers, Glenn.

Beauty is in the eye of the beerholder.