Finding a reference to anoter workbook

[TorrO]

Hi

i cant find the help by serching, so... can somb please tell me how i can find the cell/or VBA code wich is pointing to another workbook?

Thanks

 

[LTunnicliffe]

One way to do this is by closing all of the other workbooks in Excel and search for ":\". Basically it is looking for all of the D:\Directories\Whatever. Someone else might have a better solution to this...

Hope this helps!

 

[fterry]

If you go to the Tools/Options menu item, select the View tab. Under the Windows Options group click on the Formulas box so that it is marked.

This will show the formulas in your cells rather than the value. You can glance through the sheet and visually see any links.

That's the manual way of doing it anyway.

 

[TorrO]

:D
Thanks, is was so easy when i searched for ":\".

fterry: Ctrl+j gives the formulas i the cells, (norwegian language) one more time switch back to value!