Excel File Recovery

2 Methods to Get the Difference Between Two Dates in Excel

Excel will certainly do a lot of work relating to dates. In this article, we will introduce 2 ways to get the difference of 2 given dates. To calculate the time or date difference in Excel is a very common task in Excel. For example, you may need to calculate how many days that employees have worked in the company. In this image, there are the dates of different employee that working in the company. And now you need to calculate how long that they have been in this company. The following...

Read more »

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 »