How to get rid of Automatic links to another worksheet?

yjoshi · Mar 7th 2003

Hi,

In one of my files, i am getting an error

The workbook contains automatic links to another worksheet.

How to get rid of this?

I tried removing every possible link and
formula, but no effect.

Any automated script or existin feature
can solve my problem?

lambuhere1 · Mar 7th 2003

You can find any links in the file by typing ! in the Find feature of Excel. Then go to those specific cells and then remove the links. If you still have links in the file, there are many free add-ins available on the net that can perform this operation.

Ram P

Neale · Mar 7th 2003

Check all your names references Insert/Name/Define

also Charts can refer to external data

There are freeware utilities that will remove links

Dave Hawley · Mar 7th 2003

Hi yjoshi

I think this page will help:

Workbook Size Blowout and Phantom Links

yjoshi · Mar 7th 2003

Hi All,

Thanx for the suggestions.

Infact, I was going wrong way
The suggestion by "lambuhere1
" was good. Only i amended
to find ".xls" instead of "!" and
could find a solitary link refering
to outside file. :bouncy:

**royUK** · Mar 7th 2003

Here's an addin for finding links, I cannot remember where I found it. If anyone recognises it please post Author's details:coolwink:

How to get rid of Automatic links to another worksheet?

Participate now!

Share