Office Solutions

How to Solve Outlook Error “The data file was not closed properly”

This article mainly delves into the Outlook error message “The data file was not closed properly” . If receive the error prompt, you can utilize the following methods to get rid of it. On one occasion, I accidentally shut down Windows but Outlook didn’t exit ahead of time. Since then, I’ve frequently encountered the popup Outlook error message, “The data file <PST file > was not closed properly. This file is being checked for problems.” Many people may have the similar...

Read more »

3 Efficient Ways to Import External Data into Excel

Excel is very powerful in dealing with information. And today we will launch 3 methods to import external data into Excel. In your daily life, you will use some files to store some daily affairs. For example, you will use the text document to store shopping list. But later you need to import external data into Excel to arrange the information. However, you may find that the format of the pasted information in the Excel like this: Therefore, here we have three methods to import external...

Read more »

How to Use the Replace Feature to Change Your Cell Formats in Batch

There are many features in Excel. And some of them do favor to our work with simple steps. And we find such a substitute function contained in the Replace feature. Usually, you will use the Replace feature to find and replace some certain elements. And here is a sample of using the Replace feature to change cell formats. And in the image below, you can see many scores of students. And you need to select all “A” of those scores and change the format to highlight the good scores. But...

Read more »