Excel - Lost links to another workbook 1

[Geof]

In Excel 2000
When I open a particular workbook I get the message "The workbook you opened contains automatic links to information in another workbook........"

I checked all the names cell and range references....OK
I checked each cell for a ref to another workbook ....NONE
I progressively deleted sheets, saving, closing, re-openning to find the offending sheet It was sheet 1
I deleted all formulas and data in sheet 1 .... still no good (When I closed the workbook and reopenned it I got the same message)
I selected the whole sheet and pressed delete. No good
I finally deleted the sheet. Problem gone....but no spreadsheet!!!
Any suggestions please
I know I can just say no to update, but I want to know why I have the problem

Thanks

 

[petrosky]

Hi Geoff,

In Excel 97 you can open the workbook and go to Edit, Links.
This should show you what files are being linked to at the least and allow you to Change Source or Open Source.

Hope this is some help.

Regards,

Peter

Remember- It's nice to be important,
but it's important to be nice

 

[Geof]

Thanks Peter
but, i did that. it gave me the name of a file that I had previously binned. I still could not see where the link was
Thanks anyway
Geof

 

[KenWright]

Range names perhaps?
Chart source data?

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

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

 

[SQLScholar]

I found problem and found 2 solution.

1) Try going to edit>links>source and then linking to the file you are currently using (i.e. the open file) this may error, but "should" clear the link.

2) If not, if you can get use of a excel 2002/excel xp machine open the file on that. Edit>links has a break link on this version

HTH

Dan

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!

 

[petrosky]

Hi,

Also found this Website which could be of some help.

Regards,

Peter


Remember- It's nice to be important,
but it's important to be nice