MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Break links from Worksheet copy

  Asked By: Eden    Date: Feb 11    Category: MS Office    Views: 2326

I copied a sheet from one Workbook to another (I wanted a LOT of data
in the cells). Once I got the copy I did massive editing (delete
columns and such) and modded/originated quite a few Visual Basic
macros. But now whenever I open the new Workbook I get a popup that
asks if I want to update the data using links in the Workbook. I've
used the toolbar edit links to identify that it is somewhere on the
copied sheet - I have no idea where on that sheet, how they got there,
or (even more importantly to me!) how to make them go away. The
original Workbook is archived and NEVER should change.



1 Answer Found

Answer #1    Answered By: Ryan Evans     Answered On: Feb 11

there are many ways to identify  and then break  the links.

In your case, where you have a large workbook, and many links, I
would suggest the following:

Andrew's Utilities (Available at

Choose the type of installation you prefer, and then under the
menu "Other", you will find an option to break external links.

It is a great productivity enhancer, and I'll gladly advertise it
for free!!!

Didn't find what you were looking for? Find more on Break links from Worksheet copy Or get search suggestion and latest updates.