- Cant Save Microsoft Excel File Instead
- Can't Save Microsoft Excel File Recovery
- Microsoft Excel Cant Save File
Problem
Consider the following scenario: You are working on a project to automate Microsoft Office. Therefore, you have opened the Microsoft Visual Basic for Applications editor. An Excel worksheet is open as well, which contains a think-cell Excel data link (see Excel data links).
Server 2012 R2 / Hyper-V based network, Windows 8 and 8.1 workstations, large Excel 2013 file of payroll information stored on a network drive. When user clicks the Excel save icon, sometimes it saves, sometimes it doesn't. This intermittent problem can be duplicated. There is no indication of the save's success or fail in Excel. If the Excel file that you want to get back is not in the quick scanning result, click on the 'Deep Scan' button to execute a deep scan. Step 3: Recover previous version of excel file in one click. Select all desired excel files or entire folder after preview and click on the 'Recover' button to start recovering previous version of excel file.
You delete the Excel worksheet where think-cell's Excel data link resides. Excel may show an error message: 'Object required'.
If you try to save the Excel file, Excel shows an error message:
'Errors were detected while saving [file name]. Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel.'
When you click Continue, the repair fails.
Excel 2007 or 2010: Excel crashes if you try to insert a new Excel worksheet instead of trying to save the file.
Cause
The problem is caused by a bug in Excel. We have filed a case with Microsoft. If your company has a Microsoft Office Support contract and you want to contact Microsoft to ask for a fix, you may refer to Microsoft case number 114072911657591. The error can be reproduced without think-cell.
Reproduction without think-cell
Please perform the following steps:
- Start Excel with a new empty file.
- Enter 100 in cells A1 and A2 on the first worksheet, Sheet1.
- Select the cells A1:A2 on Sheet1 and press Ctrl + C to copy.
- (Only if you try to reproduce with Excel 2013 or later: Insert a second worksheet. Older Excel versions have three default worksheets, so this is not required).
- Press Alt + F11 to open the Microsoft Visual Basic for Applications editor window, and leave it open.
- Start Word with a new empty file.
- In Word, go to Home → Paste → Paste Special → Paste Link: Microsoft Excel Worksheet Object and click OK.
- In Excel, right-click the Sheet1 tab and click Delete.
Try to save the Excel file. Excel shows an error message:
'Errors were detected while saving [file name]. Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel.'When you click Continue, the repair fails.
Excel 2007 or 2010: Excel crashes if you try to insert a new Excel worksheet instead of trying to save the file.
Solution
If you encounter this error, you can save your data in a new Excel document or discard the changes and repair the original document:
Save your data in a new Excel document
To save changes you made to your document, copy the worksheets you changed to a new Excel document and save it.
Repair your Excel document to avoid this error in the future
You can repair your Excel document by deleting any Visual Basic for Applications (VBA) projects from your document. However, simply deleting them in the Visual Basic editor is not sufficient. Please use the following procedure:
Cant Save Microsoft Excel File Instead
- Create a backup of your document.
- Download and run the free Structured Storage Viewer.
- Open your document in the Structured Storage Viewer.
- In the tree view of your document, select _VBA_PROJECT_CUR and press Del to delete it.
- Confirm deletion and close the Structured Storage Viewer.
- Open the document in Excel.
- There will be a dialog box Microsoft Visual Basic → File not found . Hit OK.
- There will be another dialog box Repairs, with Lost Visual Basic project listed. Hit Close.
- Save your document.
Can't Save Microsoft Excel File Recovery
You should now be able to delete the worksheet with think-cell links and then save the document.
Microsoft Excel is an app that most of us prefer using when handling data and when we need to save important data for important tasks or for future use. However, just like any other app or program, even the Excel comes with its own set of problems.
Many times, you may receive an excel sheet via email from someone or you downloaded a spreadsheet from some website, and when you try to open the Excel sheet, bang comes an error message, “Microsoft Excel cannot open or save any more documents because there is not enough memory“.
Apparently, the issue is not related to your system memory at all. It’s mostly a security warning related to the specific file, that prevents you to open the Excel file for some reason. These warnings can be specifically for the files downloaded from the web, but may not be the same for all files.
So, how do we fix this issue? Let’s see how.
Method 1: Unblock through Properties
Step 1: Go to your desktop and right-click on the Excel file (that’s giving the error while opening), and select Properties from the right-click menu.
Step 2: In the Properties window, under the General tab, go straight towards the bottom, up to the Security section. Check the box next to Unblock.
Press Apply and then OK to save the changes and exit.
And, that’s it. You can now try opening the Excel file and it should open without any error. However, if this does not work, try the 2nd method.
Method 2 – Tweak Trust center settings
1. Open Microsoft Excel.
2. Now, Click on options
Microsoft Excel Cant Save File
3. Click on Trust center from the left menu.
4. In the right side, click on Trust center settings.
5. Now, click on protected view from the left menu.
6. Disable all protected view options by unchecking them.
Method 3: Clear Temp files
Step 1: Press the Windows + E keys together on your keyboard to open the File Explorer. Click on This PC shortcut on the left side of the window, and on the right side, click to open the C drive.
Step 2: Now, copy and paste the path given below to your file explorer and hit enter key.
Step 3: Now, press the Ctrl + A keys together on your keyboard to select all the temporary files in the folder, and hit Delete.
*Note – If you don’t see the AppData folder, then go to the View tab at the top of the folder. Click on the Show/hide option, and check the box next to Hidden items.
This will make any hidden files and folders visible.
That’s all. Now, try to open the Excel file and it should open smoothly without any errors.
I find passion in writing Tech articles around Windows PC and softwares