Excel File Recovery

3 Different Methods to Refresh Pivot Table when the Source Worksheet Data are Updated

Pivot table is quite potent in Excel. In this article, we will talk about 3 methods to refresh pivot table in Excel. The pivot table will not refresh automatically in Excel. Thus, if you have modification on the original data, you will certainly need to refresh it. For example, this worksheet records the sales volume of two products.   Besides, in another worksheet, there is a pivot table for the data and information. If you modify the original worksheet, you need to refresh the...

Read more »

How to Prevent Others from Changing Your Excel File by Marking it as the Final Version

Excel can also be in different version. And today, we will talk about marking the file as the final version to protect your Excel. When you send your Excel file to other people, you will certainly want to tell him or her that this file is the final version. Instead of telling them directly, you can also mark the file as the final version. Therefore, they can know immediately from this form. And the following are the steps about marking the file. Mark the Final Version Click “File”...

Read more »

3 Practical Methods to Move around a Worksheet in Your Excel

Some basic manipulations in Excel are very clever. And in this article, we will introduce 3 methods to move around a worksheet. You will certainly move around worksheets to check for some data and information. And except for using the mouse wheel, there are also 3 ways to move. Method 1: Use the Scroll Bar This is a very common method in Excel. But it is very useful in your actual manipulation. There are two scroll bars in the interface of worksheet: the vertical scroll bar and the...

Read more »