My Scenario: The Unsaved Excel File I downloaded an Excel spreadsheet from my bank, saving it to my computer only once, during the initial download. It may be frustrating, yet there is no need to despair as there are solutions to not only overcome this error but other corresponding errors such as freezing, hanging, etc. I honestly think it's an Excel setting, but not sure which one. Once the connection to the file is enabled then it will ask for 'Read-Write' or 'Cancel'. Once we saved a test file not even the actual files in question the macro would run without issue. Has anyone else experienced this and found a fix? Summary: Like any other program, Microsoft Excel 2016 can also fail while opening to start or sometimes during the task. When AutoSave is turned on AutoRecover files are rarely needed.
Eventually, if we wait long enough, we then are able to save the file, but the time needed to waits seems to vary. Large workbooks should be saved in Excel Binary format. Not quite as pretty to look at but the whole machine literally flies now. Your interface may look different and instructions may differ slightly from the below. However, we have four other users using the same drive, and have accessed the same file, and it works fine. They then open files from our file server which is another Windows Server 2008 r2 server. This is a request for information from anyone else who's seen this issue, inviting your suggestions for workarounds, recovery strategies, and preventative measures.
It would appear this happens when the network connection drops out. First, can you open any other excel file on your mac? It's certainly worth a try before loosing all work. With this done, open Finder and type AutoRecover in the Spotlight search box. Go to Previous Versions, find and select the latest version or the right version before Excel crashes, deleted or saved, click Restore. You can then recover unsaved files and restore the previous session.
Create a new Excel file with the same name of your lost Excel file or find your present Excel file. You can set how frequently these AutoRecover files are saved. I've tried it with Current documents and New documents. Wait untill you get the option 'Read-Write' before closing the file. The same users had no issues using the same macro to save to a local shared drive.
. However, I can't be 100% certain about this - I will try it again the next time I get this annoying problem. AutoSave is a different feature which automatically saves your file as you work - just like if you save the file manually - so that you don't have to worry about saving on the go. Regards, Prashanth My issue got fixed using the below procedure thanks for Richard. Because the AutoRecovery file has been hidden, you need to make it visible to recover unsaved Excel file. It whines about permissions, but, if I log in as the user on another computer, it isn't a problem.
If you are facing any one of the problems, just follow and find solutions here to perform Microsoft Excel 2016 recovery and get your lost Excel file back now. It can help identify the file on your system if it exists. The result was a temp file, but my original file was gone completely from File Explorer! First, open the Excel file. Please let us know if this helps. Before you do, try or on a copy of the file. It might be the Mac is also not locking the file properly in the file server. You would need to boot from some other drive to repair the boot drive e.
This could cause it to connect to the users home drive under another user name with different file permissions to the home folder. Type Parameters in the box. When the power is up, you restarted your system to check your Excel. Before starting the process you must quit all Office applications, including Outlook, Excel, Word and PowerPoint. If you type of file does save such as xls and another such as xlsx doesn't save, I go to the File Block Settings under the above settings path and review the different types of Open and Save options that appear there.
A hassle, but less so I think than exporting each module and reimporting them. The problem is that I can see one of the. Click the arrow next to the Open button, and then click Open and Repair. Hey All, I have been working on an excel file using both a mac and a pc. She is getting this same error - Document Not Saved - for any Excel file she tries to save to our shared drive. You can also apply this Mac data recovery software to , music, videos or other data on Mac for free.
How to Recover Unsaved Excel File on Mac How many of you have ever met this problem that the Excel is suddenly stuck and fails to respond to Mac? Hi Lee, If the excel problems happens again please follow the below steps: 1. After it re-connects excel creates a second temp file and the only way to save it after there are two is to delete the old temp file and then try to save it again and it should go through I know this isn't exactly what the original poster was referring to but this is exactly what has happened on a couple of occasions to some of my users. For those applications AutoRecover files are stored in the folders we listed above. Hi, I've still had no new issues reported regarding this so the problem appears to have been network connection related at least in my case. We believe it is an issue between windows 10, office 2016 and kaspersky.
She can save a Word document to the shared network drive - so it's not like she doesn't have permissions. I considered going through the settings for the Ethernet card and changing some of the adapter defaults. It would appear this happens when the network connection drops out. As a leading data recovery tool, it allows you to do Office document recovery, , photos recovery, as well as other data recovery. While opening a shared excel file if the network is slow It will ask for 3 options. Furthermore, Stellar Data Recovery Professional for Mac software makes the process quite easier as you have to simply make selections and this takes care of everything. After doing so my Excel problem disappeared :- Succes! Dave - There's enough information for it to be more than a comment; it's an answer, but not the full answer.