Removing linked info

[Melba's Jammin']

Office 2001

I have a "master" file wherein two worksheets are linked so that when I
change a number in Worksheet A within the document, the information also
changes automatically in Worksheet B.

From Worksheet B, I have created Worksheet C which is basically the same
information as Worksheet B, but I do not want the information on
Worksheet C to automatically change.

IF file Worksheet C is unopened, upon opening it I am given an alert
that it contains linked info and do I want to update it? I say no and
life is swell.

If file Worksheet C is open at the same time as the "master" file and I
make a change to that file, the info on Worksheet C changes.

Is there a fast way to remove the links? Or must I do it one at a time?
I'm not finding it in the Help file -- may not be looking in the right
place. When I go to Edit -> Links, the Automatic update button is
selected and the Manual update button is greyed out and not functioning.

Thanks for your patience; I await your advise.

-Barb

 

[JE McGimpsey]

Is there a fast way to remove the links? Or must I do it one at a time?
I'm not finding it in the Help file -- may not be looking in the right
place. When I go to Edit -> Links, the Automatic update button is
selected and the Manual update button is greyed out and not functioning.

The fastest way is to copy the data then immediately choose Edit/Paste
Special, selecting the Values radio button.

 

[Melba's Jammin']

The fastest way is to copy the data then immediately choose Edit/Paste
Special, selecting the Values radio button.

Thank you!! I should have thought of it myself!

 

[Melba's Jammin']

The fastest way is to copy the data then immediately choose Edit/Paste
Special, selecting the Values radio button.

And someone in another group said I can also paste in the formatting
from the source file, too, so I don't have to reformat the new file!
Hurrah! Thanks again.