4 WAYS TO FIX WHEN MICROSOFT EXCEL CAN NOT OPEN OR SAVE ANY DOCUMENTS

Microsoft Excel is being used worldwide as the most trusted and capable software to maintain data and input of the organisation. It is the best way to store data in one place and easy to access it back but sometimes, some excel file we receive doesn’t open and comes with a flash message.

“MS EXCEL CAN’T OPEN OR SAVE ANY MORE DOC CAUSE THERE IS ENOUGH MEMORY SPACE NOT AVAILABLE”

So, how to fix this issue??

Apparently, this issue does not mean that the file is corrupted or your ms-excel is not working properly. This is just a secure way to proceed and prevent unwanted malware that comes along with spreadsheets. but you can go and change it in settings to run the excel file.

Many excel files until 2007 are saved in a different format that is XLS and after 2007 files use extensions in XLSX format so, modifying the format can actually be made it possible for files to open easily.

FOUR WAYS TO OPEN MS EXCEL FILE.

1. TEMPORARY SOLUTION 

Sometimes files are not directly allowed to open and are in the restricted mode so just allowing them by unblocking can actually work. This is the most basic solution which is done with two clicks only and the most common solution to open an excel file.

STEPS TO FOLLOW

  • RIGHT-CLICK ON THE MS EXCEL FILE
  • GO TO PROPERTIES
  • CLICK ON UNBLOCK 

After clicking on unblocking the file that doesn’t open up earlier is now easily able to open if it is just blocked and not having any further issues.

2. PERMANENT SOLUTION 

This solution is required to go to the main settings of the excel file to allow the settings that are restricting it to open and this actually is done by deleting the existing hidden file that is actually blocking the file to open.

STEPS TO FOLLOW 

  • CLICK ON MY COMPUTER
  • OPEN C-DRIVE
  • GO TO USER
  • OPEN APP DATA
  • OPEN LOCAL
  • CLICK ON TEMPT
  • SELECT ALL THE FILES AND DELETE IT

After deleting all the files in there those files which are restricting the excel to open are now deleted and now your file will be open easily.

3. OPEN FILE IN VERSION MS EXCEL 2013 AND ABOVE

There is also a possibility that the settings of the TRUST CENTRE will be changed and allow the location of the file directly through the trust centre. This indicates the file is safe and easy to access after that.

STEPS TO FOLLOW

  • OPEN MS EXCEL
  • OPEN FILE
  • GO TO OPTIONS
  • CLICK ON TRUST CENTRE
  • CLICK ON TRUST CENTRE SETTINGS

AND choose the file that is having trouble while opening.

  • Also, don’t forget to click on the subfolder also

4. UNCHECKING BARS IN TRUST CENTRE

Sometimes just some unchecked bars can do a lot of things and lead to opening some rusted files that you think might be corrupted.

Steps to follow 

  • OPEN MS EXCEL 
  • OPEN FILES
  • CLICK ON OPTIONS
  • CLICK ON TRUST CENTRE 
  • CLICK ON TRUST CENTRE SETTINGS
  • OPEN PROTECTED VIEW
  • UNCHECKED ALL BARS ONE BY ONE

There are a total of three bars which can be checked one by one and then press ok. This actually disables the protected view for the files from the internet, unsafe location and outlook attachment. Boom, your spreadsheet is ready to open.