Another Method of Showing Recalculation in MS Excel

While doing some research for a reader's recent query regarding automatic recalculation in the MS Excel Status Bar, not only did I find an answer for the reader, I also found an alternative method of watching the recalculation without using the Status Bar in MS Excel 2007.

Turns out you can take a picture link of a cell and place that picture link any place you like in your Workbook. When the cell changes, it will show the change in the picture link.

You can use either of the two methods below:

• You can use the Paste Picture Link command after copying the cell of interest
   
• You can scroll through the Commands not on the Ribbon options in Excel Options, locate the Camera tool and add it to the Quick Access Toolbar (QAT) so it will be readily available to take a snapshot of any cell you would like to keep an eye on.

I think you will like experimenting with this!

When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!