Excel File Recovery

How to Monitor the Changes in Your Excel through the Camera Tool

In an Excel file, you will certainly change some values. Thus, to monitor the change of result is very important. And the camera tool can be a very effective method. In our previous article, we have introduced about the Watch Window: How to Monitor the Changes of Important Cells through Watch Window in Excel. And in this article, we have another method which has the same effect. In this image, the source of the total number is from another worksheet “Sales Volume”. And this is a...

Read more »

What to Do if Excel Fails to Calculate the Values Copied from External Sources

In Excel, you will certainly do some work of calculating. Thus, today we will talk about the calculation problem appearing in values copied from other sources. Excel specializes in dealing with the calculations of numbers. However, there exists a problem in doing some calculations. Sometimes, if you copy the values from other sources, i.e. from a website, you will find errors in the calculation. The Error in Calculating Copied Values In this image, the currency values are copied from...

Read more »

How to Add Check Boxes and Option Buttons in Your Excel Worksheets

Excel allows people to set options in worksheets. Thus, today we have the usage of adding check boxes and option buttons into Excel. One of the functions of Excel is questionnaire. For example, if you are a teacher, and you need to know what your student want to do and what fruit they like, you can use the Excel files to collect the result. So you can use the check boxes and option buttons to finish the worksheet. Add Developer Tab in the Ribbon Before you add the check boxes or option...

Read more »