excel warning message no more disk space

#Excel warning message no more disk space code
#Excel warning message no more disk space windows

I then restored the temp file from the recycle bin. I was able to open another instance of Excel and copy-and-paste the data contents of my file to that, and save that as a backup (some people report that attempting to copy in this situation crashes Excel, perhaps because they have huge files.) I did not try adding the NetworkResiliency subkey to the registry as explained in Microsoft article KB230164. Excel refused to Save no matter what I tried. I deleted the temp file in File Explorer and attempted saving the still-open file to a local drive as suggested by Microsoft, but that didn't work. The result was a temp file, but my original file was gone completely from File Explorer! Scary. Excel saves first to a temp file and then renames that to the correct original filename, but that process was corrupted by my clicking Save (to a network drive) a second time too quickly.

#Excel warning message no more disk space windows

Windows responded by suggesting I close Excel and open the 8-letter (no extension) temp file Excel had saved, but I was fearful of losing a great deal of work so I ignored that advice. In my case, the 'Document not saved' problem was caused by my attempting to save a spreadsheet with macro (VBA) to a network drive too quickly after doing the same thing a few seconds before (I wasn't sure if I had properly clicked Save the first time, using Excel 2000 in Windows 8.1, so I clicked it again). I am not aware of any correlation with service packs, hotfixes, or third-party antivirus software.All other versions of Excel from 1997 onwards can and will.I haven't seen the problem in Excel 2007 or 2010, but I haven't used these later versions of Office enough to conclude that they don't exhibit this issue.The network administrator is very annoyed about the traffic and the server space.I can't save the file from the current Excel session.I've mostly seen it with large files (over 50 MBytes) but today I saw it with a 780-kB file.

#Excel warning message no more disk space code

I've only ever seen it after I've worked on VBA code in the file AND hit 'compile'.I've only ever seen it over a network drive.A close reading of Microsoft's KB article on 'Document not saved' suggests that someone in Redmond has seen each separate part of the problem, but can't quite bring the parts together in a KB article that would acknowledge this specific issue. I've seen this problem in four different companies one of them (a large financial institution in New York, London, Zurich and Singapore) uses very large and complex spreadsheets with a lot of VBA, and most of the Excel developers have seen the problem. Nothing works: saving again repeats the process, 'Save As' into another file format (eg: a web page) repeats the process, after a delay. If you don't have an earlier copy of the file with your changes (or something in the autosave folder), you're completely out of luck: all your work since the last successful save is lost. This will take 10-15 minutes if you're lucky, and several hours if you're not. Shortly after 2 GBytes - or if you run out of disk space - the temp file is deleted and Excel returns the 'Document not saved' error. Specifically: the Excel Application window stops responding to user input, but the screen still repaints and a 'Saving :' progress bar is visible in the application window. As soon as the write operation to this temp file is completed, the original file is deleted and this temp file is renamed to the original file name. Have you ever watched the folder your Excel workbook file is saved in, when you click 'Save' in Excel?ĭuring the save process, Excel creates a temp file, with an arbitrary 8-character This is a request for information from anyone else who's seen this issue, inviting your suggestions for workarounds, recovery strategies, and preventative measures. You've lost all your work since the last successful save.

Your current Excel session cannot save the file, no matter what you do.

Saving an Excel workbook sometimes runs very slowly.