Mystery Links 1

[Vamphyri]

Here's one for you Sherlock Holmes wannabes.

I copied a worksheet from workbook A into workbook B. Made some modifications and saved workbook B. During the modifications I entered all new formulae.

Now, whenever i open workbook B password dialogue box opens requesting the password for workbook A.

I have already removed all external links from workbook B.

Any ideas?

This one is causing major heart palpitations.


In the immortal words of Socrates, who said:
"I drank what?

 

[KenWright]

Links are probably buried in named ranges or in chart ranges. Either search through them manually, or try Bill Manvilles free FINDLINK addin:-

http://www.bmsltd.ie/mvp/

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

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

 

[Vamphyri]

Ken,

Thank you so much.

Now all I have left to do is clean up all of my ripped out hair that's strewn about my desk.

Star for you!


In the immortal words of Socrates, who said:
"I drank what?

 

[KenWright]

LOL - Does get frustrating when you think you'vre searched through it all and not found anything.

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