When you try to open an excel files download from internet, get from skype or in mail attachment, you cannot open it. All you get is a notice from Windows “Microsoft excel cannot open or save any more documents because there is not enough available memory or disk space. To make more memory available, close workbooks or programs you no longer need To free disk space, delet files you no longer need from the disk you are saving to.”
But when you check disk space if fine, free RAM > 1GB.
So, what’s problem here? Let’s find and fix it.
Causes of Excel cannot open or save
Error “Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space” occurs due to the two causes.
One is due to insufficient memory.
Two is due to the Microsoft Excel file you downloaded from the Internet or copied from another machine.
Therefore, you must find out whether the error is caused by any cause.
Fix for Microsoft Excel cannot open or save
Microsoft Excel error due to insufficient memory RAM
If due to insufficient memory, shutdown programs are running. If not due to memory, it can only be caused by cause no. 2.
To test the memory, you can press Ctrl + Alt + Delete. A Task Manager panel will appear. Switching to the Performance Tab you will see the blank RAM as below screenshot shows.
If the RAM is too low, it may be due to insufficient memory.
Then, you just close some programs running with high RAM. You can check which running high RAM in Processes tab.
File downloaded from the Internet or copied
Step 1: Open a new Excel file, and then from Menu File you choose Options/Trust Center/Trust Center Settings (bottom right)
Step 2: A new windows windows Open, you choose Protected View Tab, then Uncheck all three settings there.
Enable Protected View for files originating from the Internet
Enable Protected View for files located in potentially unsafe locations
Enable Protected View for Outlook attachments
Step 3: Click OK / then OK, then Restart Excel. You might be able to get it to work by unchecking one and testing, up to you.
With those files you downloaded on your computer, please Right click on that files, choose Properties, then click on to Unlock.
- Hướng dẫn sử dụng outlook: Cài đặt font chữ, màu chữ mặc định
- Gộp nhiều email cùng chủ để – view email messages by conversation
- Cách tạo và thêm chữ ký trong Microsoft Outlook
- Máy tính văn phòng cần cài những phần mềm gì?
Other Posts you may be interested in:
- Một số thủ thuật với htaccess Mod Rewrite
- Những mẫu bánh kem sinh nhật ngộ nghĩnh
- 4 điều nên biết khi chọn mua bộ cọ trang điểm cá nhân
- Cách ăn chay, hay ăn thực dưỡng theo bài số 7
- Fix lỗi dispatcher.php và event.php trên PHP 5.3 and higher
- Lịch thi đấu, bảng xếp hạng C1/Champion League 2015-2016
- Cách khóa máy và xóa dữ liệu từ xa trên android phone
Last updated on June 27th, 2020 at 06:05 pm