Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Nov 2001
    Location
    Houston, Texas
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Document Not Saved (2000/SR-1)

    When I try to save my Excel spreadsheet, I received a message "Document not saved". I also have one cell that has more text in it than I can display, even by changing the row size to its maximum. Could this be why the spreadsheet cannot be saved?

    Thanks,

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Document Not Saved (2000/SR-1)

    In itself, long cell contents shouldn't be a problem. A cell can contain up to 32,767 characters, but only the first 1,024 are displayed in the cell itself.
    Can you copy the contents to a new blank spreadsheet, and save that?

  3. #3
    Star Lounger
    Join Date
    Nov 2001
    Location
    Houston, Texas
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Document Not Saved (2000/SR-1)

    Yes, copying to a new spreadsheet worked.

    Thanks,
    Caroline

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Document Not Saved (2000/SR-1)

    Hans,
    I have encountered the same problem with a multi-worksheet file (>10 worksheets), even though I may only be editing one of the worksheets.
    Any ideas?
    Thanks in advance,
    Jeff

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Document Not Saved (2000/SR-1)

    Jeff,

    There are several possible causes for this problem:
    <UL><LI>The disk is full, or almost full.
    <LI>A network glitch while Excel tried to save the workbook.
    <LI>Too many files in the Temp folder (it doesn't hurt to clean out Temp from time to time)
    <LI>See XL: "Document Not Saved" Error Message When You Use Linked Embedded Objects.
    <LI>A conflict between Excel and your virus scanner.[/list]It's impossible for me to guess which of these (if any) applies to your situation. Usually, you will be able to save the workbook under another name or to another drive, or to copy the worksheets to a new workbook, and save that.

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Document Not Saved (2000/SR-1)

    Thanks, Hans. In all probability, it is probably a network glitch!

  7. #7
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Document Not Saved (2000/SR-1)

    Just to share experience: over time, I've developed the habit of hitting Ctrl+S (keyboard shortcut for save - two fingers on the left hand) when developing something in a large workbook. This does give some kind of "buffer" in case the dreeaded "Document not Saved" message does turn up. I'm not a great fan of Autosaving Add-Ins. HTH
    Gre

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •