What should I do if Excel prompts that there is insufficient memory and cannot be opened?

The solution to the problem that excel prompts that there is insufficient memory and cannot be opened: first open the excel file, click File, Options; then enter the Trust Center option, click Add New Location; finally select a drive letter and check [Also trust this location] subfolder], click OK.

The operating environment of this article: windows10 system, microsoft office excel 2010, thinkpad t480 computer.

The specific method is as follows:

First open an Excel file, click the [File] option in the upper left corner, and select [Options] in the drop-down menu.

Select the [Trust Center] option on the left and select the [Add New Location] option on the right.

Click the [Browse] option. , click the corresponding drive letter, and then click the [Select Folder] option in the lower right corner.

Then check the [Also trust subfolders in this location] option and click [OK].

Add all the drive letters in sequence. You can see the added trusted drive letters in the list, and then click [OK] in the lower right corner to save the changes. This way This successfully solved the problem of insufficient memory.

Related recommendations: excel tutorial

The above is the detailed content of What should I do if Excel prompts that there is insufficient memory and cannot be opened?. For more information, please follow other related articles on the PHP Chinese website!