Glenn,
Sorry I should have pointed out that the file is protected and that several users outside of the dept. access this file on occasions (via the password on the file). Those users outside of the dept. have in the past linked their files to this one file. Obviously if I delete rows in my file which users have linked to, then this generates a #Ref error in their files.
What I was trying to do was to eliminate any attempt to link to my file, but having researched various Excel boards & the Microsoft site, I'm beginning to think that this is impossible.
Again thanks for your response.
Jon