Removing a linked worksheet in Excel 97 2

[Dual]

How do I remove a linked worksheet in Excel 97? I searched past posts which refer to a remove/delete link button which does not exist in Excel 97.

Doug Corbett
Dual Inc
Newton MA 02458-1187
accounting@dual-inc.com

 

[rdodge]

What do you mean by a linked worksheet? A worksheet that has external formulae references?

I don't know of any way how worksheets can be linked like how worksheets are linked in an Access table. unless you using some sort of query program like MS Query, but even that mainly opens up the workbook that it's in.

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000

 

[Dual]

Ronald,

Correct - External formulae references would create such a link. However this file should not be referencing anything external. It was created from scratch & does not have a need to link externally.

When I open the specific file (I'll call it abc.xls), Excel asks if I want to update abc.xls with linked workbooks. I answer no because the file should not be linked to anything. Even if I answer yes, there are no changes made because there is nothing to change.

Then I go to Edit/Links. There is another file (I'll call it lmnop.xls) that is actually linked abc.xls. The only options for me are to open lmnop.xls or update the location of lmnop.xls or pick another file to link to. However there is not an option of removing the link altogether. I have discover in my search that there is a "delete link" button in newer versions of Excel but not Excel 97. Any internal help features only lead to setting up links. Web searches lead to Excel 2000 or beyond where the solution is easy.

I would like abc.xls to be wild & free on its own, linkless, like any other ordinary Excel file. Any help would be great.

Thanks,

Doug

 

[PeterMoran]

Hi Doug,

Checkout these links:

Q188449 -- XL97: Delete Links Wizard Available

http://support.microsoft.com/default.aspx?scid=kb;en-us;q188449

FindLink by Bill Manville:

http://www.bmsltd.co.uk/MVP/Default.htm

and John Walkenbach's Tip #54)

http://j-walk.com/ss/excel/usertips/tip054.htm

Good Luck!
Peter Moran

 

[rdodge]

Prior to me having any of these tools available, had to do the following for the different types:

Formula link

Use the Find dialogbox (each worksheet individually) to find any formula that included the ".xls" in it.

MS Query

Data>External Data>Data Range Properties

Defined Names

Goto Insert>Name>Define

and check each named range/formula for external references

Charts

Had to look at the source data section

Objects

I don't really remember at this point of time

Hidden names

I haven't dealt with it, but the only place where it could be checked out as far as I know was in the VBA like via the Watch Window.

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000

 

[Dual]

Thanks for the help. The delete link add in works great!

Q188449 -- XL97: Delete Links Wizard Available

I also read Q136314:

http://support.microsoft.com/default.aspx?scid=kb;

[LN];Q136314

It states how phantom links can start in cases where you copy tabs without links from another workbook where links exist. When you paste in your new workbook, you can carry the links forward even though the tabs were linkless.



Doug Corbett
Dual Inc
Natick MA 01760
accounting@dual-inc.com

 

[JBaileys]

Regarding using...

Data>External Data>Data Range Properties

My data range properties link is grayed out. Is there anything that I can do to "enable" this option.

 

[PeterMoran]

Hi,

Suggest you start a new thread.

Regards,
Peter Moran

 

[JBaileys]

I was able to delete the link by pointing the spreadsheet to itself in the references. Seems a little querky. It seems like MS should give you an automatic option to delete all linked references

 

[KenWright]

In later versions they do

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------