linking information 1

[mirage10]

excel 2000

Hi I have a report which has formulae in it.
Previously it had linking from other work books too and i tried to remove them, but i think they were not removed completely and every time i open the work book i get the error message "u have linked information from other workbooks"

is there a way to know which cells have the linked information from other work books.. the excel sheet is so big it is humanly not possible to search cell by cell manually

------------------------------------------
A Man can be only as happy.. as he makes up his mind to be

 

[lupins46]

Have you tried Edit>Links?

 

[Xaqte]

Does this help?

http://office.microsoft.com/en-us/assistance/HP030560961033.aspx

 

[KenWright]

Bill Manville's free FindLink utility will find/fix all links for you:-

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

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

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