Occasionally, you'll be working on an Excel document and when you try to save it, it says "Document not saved."

DocNotSaved[1]

To get around this problem quickly, you can

  1. Select all your worksheets (Click the first sheet + SHIFT + Click the last sheet)
  2. Right click on one of the sheets
  3. Choose Move or Copy...
  4. Click "Create a copy"
  5. Click the drop down box, and choose (new book)
  6. Click "OK"
  7. You'll now be able to save your new workbook (and discard the old one

Alternate solutions:


  1. http://2.bp.blogspot.com/-SiXUYnJgLhU/TzA7FFjXz9I/AAAAAAAAmFg/MDjl-URVs-s/s400/Microsoft%2BExcel%2B-%2BLoadTestResults201202.xlsx%2B262012%2B13738%2BPM.bmp.jpg "Document not saved." ↩︎