add a watch to excel 2010

[kgkev]

In Excel 2000 I could "watch" a section of a different work sheet from my main page.

This still works in 2010 but I cannot find how to create a new one.

I have found the watch window but this isn't really what I want.


The old watch was like a screen print picture of another book that would auto update.

Anyone know where the option is now?

 

[VoG]

Do you mean the Camera Tool? You can add it to the Quick Access Toolbar.

 

[kgkev]

Thats the one - Thanks