Results 1 to 13 of 13
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Saving changes message (2000)

    For some unknown reason when l am exiting a spreadsheet file.
    I keep getting message "Do you want to save changes?"

    Yet l have made no changes to database.
    Any ideas as to why this message appears?
    It does not appear on any other spreadsheets l use.
    see attachment.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving changes message (2000)

    There are some functions that always recalculate, like NOW() and TODAY() and some others. They cause Excel to think your sheet has changed and thus it asks whether you want to save.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving changes message (2000)

    How do l go about removing these commands as l have deleted all macros that do these functions.
    One spreadsheet appears to be ok , yet the others come up with the error.

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

    Re: Saving changes message (2000)

    But does the workbook contain formulas in cells with functions that always recalculate, such as TODAY() or NOW() ?

  5. #5
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving changes message (2000)

    I have been through the worksheets and cannot see any evidence of this.
    Any suggestions, shall l send you the worksheets?

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

    Re: Saving changes message (2000)

    You can attach an example workbook. If it's too large, create a zip file and attach that. If the workbook contains sensitive data, remove them, but don't remove formulas.

  7. #7
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving changes message (2000)

    see attachment.

    Justin

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Saving changes message (2000)

    You did not attach anything

    Steve

  9. #9
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving changes message (2000)

    File was to large to attach.

    I cannot think of a way to reduce size of file in Excel.
    Is there any think l can check in the file which l have not done so already?

  10. #10
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Saving changes message (2000)

    You could (in a copy) delete some of the sheets. Move some of the sheets to new workbooks and see if they give the message and just attach one of the sheets that does.

    Steve

  11. #11
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving changes message (2000)

    I have resolved it.
    There appears to be something in the last worksheet such as one of commands you suggested.
    But what cell is l have no idea?
    Any ideas as to how l can track the command down in the worksheet?

  12. #12
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Saving changes message (2000)

    edit - find
    now
    or
    today

    Steve

  13. #13
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving changes message (2000)

    That works fine thanks.

Posting Permissions

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