Results 1 to 15 of 15
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    'Do You Want to Save' message (Excel97/2000)

    I have a workbook that never contained macros (and still doesn't). Now I notice that when I open and immediately close it (no changes were made to any cell), I get the message "Do you want to save the changes you made to 'filename.xls'." Why does this message come up when nothing was changed? It's got to be something messed up internally but since there' s code (or add-ins) what could cause it?

    How can I get rid of it?

    Thnx, Deb <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: 'Do You Want to Save' message (Excel97/2000)

    Deb,

    Would you have any formulas or links that are updaiting automatically. Formulas using TODAY() or NOW() would cause an update.

    Andrew C

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Do You Want to Save' message (Excel97/2000)

    Good thought there.. but no, I don't use those at all. I checked all formulas and only have 5 types (sum, round, if, ceil, floor) + regular cell references. Something has happened to this file because it never used to display this message if I just open/close the file. I guess it's yet another fault of Excel's poor garbage collection or internal crumminess. I'll go ahead and copy all the sheets to a new workbook. That should get rid of the message but it still doesn't explain what got messed up.

    Thnx, Deb <img src=/S/drop.gif border=0 alt=drop width=23 height=23>

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

    Re: 'Do You Want to Save' message (Excel97/2000)

    No (hidden) names with those formula's?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Do You Want to Save' message (Excel97/2000)

    Yes, the model does use named vars to reference cells. A few formulas do reference these named cells. How would using named vars affect whether or not Excel thinks the model has changed? Also this wouldn't explain the fact that the model never used to ask "do you want to save" when it was just opened and immediately closed.

    Hmmm, so what are you thinking about named vars that might point to to what's going on? I use them a lot.

    Deb <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

  6. #6
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Do You Want to Save' message (Excel97/2000)

    Thanks again. No formulas are using things like Now() or Today() as everything in the model is financial-type data (quarterly totals). There are no UDFs either as a matter of fact there is no code (VBA), no macros at all. I tried the FindLink program but it didn't come up with anything that I would recognize as causing a change. I really think now it's just a quirk in Excel where it got itself twisted internally and I need to rebuild the application.

    Oh, well, time to rebuild *yet again*

    Thnx, Deb <img src=/S/hairy.gif border=0 alt=hairy width=15 height=15>

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

    Re: 'Do You Want to Save' message (Excel97/2000)

    Is it too large (or confidential) to attach to a msg here?

    Other thought: Does it still do this when you first open XL without any add-ins:

    Start, Run,

    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Automation

    Quotes mandatory, Note you may have to change the path.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    Lounger
    Join Date
    Jan 2001
    Location
    Basalt, Colorado, USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Do You Want to Save' message (Excel97/2000)

    I have had that problem with functions such as CELL("filename"). Just a thought.

    Dan

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

    Re: 'Do You Want to Save' message (Excel97/2000)

    <<Prompts to save 'updates' caused by volatile formulae can be nailed with a macro, at the risk of being prompted about whether you want to allow macros to run, depending on how you've got Excel configured:
    >>

    Rather risky, since it also prevents the save question when you've made "real" changes...
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  10. #10
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: 'Do You Want to Save' message (Excel97/2000)

    This behaviour isn't restricted to time-dependant formulae like today() and now(). Two others that spring to mind are rand() and offset().

    Prompts to save 'updates' caused by volatile formulae can be nailed with a macro, at the risk of being prompted about whether you want to allow macros to run, depending on how you've got Excel configured:

    Sub Auto_Open ()
    ThisWorkBook.Saved = True
    End sub
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  11. #11
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: 'Do You Want to Save' message (Excel97/2000)

    Hi Jan,
    That isn't how Excel 97 works - try it with the attached file. This does not give a prompt for a change caused by the volatile TODAY() formula, but does if the user makes a change. Maybe you were thinking of:

    Application.DisplayAlerts = False

    which would have that effect.
    Attached Files Attached Files
    Cheers,

    Paul Edstein
    [MS MVP - Word]

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

    Re: 'Do You Want to Save' message (Excel97/2000)

    Sorry for this, I misread your post, thinking the saved=false part was in an Auto_close macro.
    Clever to have it in the auto_open macro.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  13. #13
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Do You Want to Save' message (Excel97/2000)

    Unfortunately I can't use any macros in this .xls file so can't use your suggestion. I checked again the formulas as no one uses rand() or offset(), I only use the 4-5 that I mentioned before. I think something changed internally since this model never used to have this problem and no formulas were changed (yeh, I know they always say "but I didn't change anything") *ha*

    I decided to make a copy of the file and then one by one delete a sheet to see if the problem goes away (delete one sheet, save,exit, re-open). That way I can at least narrow it down to one (or more) sheets. I can't send the model as it contains proprietary information.

    I appreciate your ideas though <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

    Deb

  14. #14
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Do You Want to Save' message (Excel97/2000)

    PROBLEM SOLVED!! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

    I deleted one sheet at a time until the problem went away then focused on that one sheet. It turned out that the combo box I had used from the Forms tool bar was causing the message to appear even if nothing was changed (at least nothing that I could see). I have 6 of these combo boxes on this one sheet and when replaced them with 6 list boxes, the message no longer appeared.

    First I thought t was just one combo box, but it wasn't. So something about combo boxes internally causes something to change such that Excel prompts you at close. I tried it with the combo box in the Controls (ActiveX) tool bar and those worked fine (no erroneous 'do you want to save' msg).

    Yippie, Deb <img src=/S/groovin.gif border=0 alt=groovin width=21 height=21>

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

    Re: 'Do You Want to Save' message (Excel97/2000)

    I just meant to ask whether there are any named formula's that contain function's like NOW, TODAY, etcetera.

    I don't know what e.g. Application.Volatile causes to happen to UDF's regarding your problem. Got any?

    Have you tried my flexfind utility to look for NOW or TODAY? Maybe even better: have FINDLINK from Bill Manville look for them, it will look inside Named ranges as well. Find it at http://www.bmsltd.ie/mvp

    Edited Mar 13th 2004 to update link
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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