Removing links between spreadsheets

M

mark gill

Is there a way to remove links without pasting info as
values when sending a file via email as i wish to keep
other formulas

many thanks
 
J

Jim Rech

If you have Excel 2002 or 2003 you can use Edit, Break Links. Otherwise, if
you do not have too many links you can convert them to values by selecting
each one and doing an Edit, F9, Enter.

--
Jim Rech
Excel MVP
| Is there a way to remove links without pasting info as
| values when sending a file via email as i wish to keep
| other formulas
|
| many thanks
 
Top