Aug 07, 2013

How to switch between workbooks using Watch Window in Excel 2013?

In earlier versions of Excel, I often used Watch Window to switch between worksheets by double clicking the cell displaying the desired worksheet in the Watch Window, and it didn’t matter if the worksheets were in the same workbook. In Excel 2013, this only seems to work if the desired cell is in the same workbook. Am I doing something wrong here? Is there a setting that needs to be changed for this to work the way it used to?

Here's a video that might help.



I don’t think it works the way it did before Excel 2013. Maybe there is a setting somewhere that I have missed too, but it seems like the feature has either been removed for some reason, or it is broken.  

Answer this