+ Reply to Thread
Results 1 to 4 of 4

Excel prompt to save unmodified files

  1. #1
    Alan
    Guest

    Excel prompt to save unmodified files

    Excel keeps asking to save unmodified files, very anoying after a while.

    Any Idea

    SP3 installed



  2. #2
    Dave Peterson
    Guest

    Re: Excel prompt to save unmodified files

    There are worksheet functions that are volatile. They recalculate whenever
    excel recalculates the workbook.

    Do you have functions like:

    AREAS()
    INDEX()
    OFFSET()
    CELL()
    INDIRECT()
    ROWS()
    COLUMNS()
    NOW()
    TODAY()
    RAND()

    And newer versions of excel like to recalculate older workbooks when they're
    opened. Then xl knows that the file is changed and prompts you accordingly.


    Alan wrote:
    >
    > Excel keeps asking to save unmodified files, very anoying after a while.
    >
    > Any Idea
    >
    > SP3 installed


    --

    Dave Peterson

  3. #3
    Alan
    Guest

    Re: Excel prompt to save unmodified files

    No I don't have any of those functions.

    I fact I just created a new sheet with just some text in one cell
    Saved as book1
    Reopened, did nothing and got the save doument prompt when I closed it??

    Thanks for your reply

    Alan

    "Dave Peterson" wrote:

    > There are worksheet functions that are volatile. They recalculate whenever
    > excel recalculates the workbook.
    >
    > Do you have functions like:
    >
    > AREAS()
    > INDEX()
    > OFFSET()
    > CELL()
    > INDIRECT()
    > ROWS()
    > COLUMNS()
    > NOW()
    > TODAY()
    > RAND()
    >
    > And newer versions of excel like to recalculate older workbooks when they're
    > opened. Then xl knows that the file is changed and prompts you accordingly.
    >
    >
    > Alan wrote:
    > >
    > > Excel keeps asking to save unmodified files, very anoying after a while.
    > >
    > > Any Idea
    > >
    > > SP3 installed

    >
    > --
    >
    > Dave Peterson
    >


  4. #4
    Dave Peterson
    Guest

    Re: Excel prompt to save unmodified files

    Do you get the same problem if you open excel in Safe mode:

    Close excel
    windows start button|Run
    excel /safe
    file|open your book.xls

    File|close (no changes)

    If you get prompted, I don't have a guess. If no, then maybe you have a macro
    that's helping out.

    Chip Pearson has a page that can help you find that helpful macro:
    http://www.cpearson.com/excel/StartupErrors.htm

    ========
    There have been a few problems associated with Google's Desktop Search. Do you
    have that installed on your pc?

    If yes, maybe disabling that COM Add-In will help.

    One way to turn it off:

    In excel,
    Tools|customize|Commands tab|Tools Category
    Scroll down the commands listbox and
    Drag "COM Add-ins..." to under Tools|Addins
    (It seems to make sense there.)

    Then close up that dialog.

    Back to Tools|COM Add-ins...
    Turn off the google desktop search addin.

    (You could use a registry tweak, too. But I think that this is safer/easier.)

    ===
    This google addin shows up in other Office applications, too. You may want to
    look at disabling it in those other office programs, too (well, if you
    experience problems).

    Alan wrote:
    >
    > No I don't have any of those functions.
    >
    > I fact I just created a new sheet with just some text in one cell
    > Saved as book1
    > Reopened, did nothing and got the save doument prompt when I closed it??
    >
    > Thanks for your reply
    >
    > Alan
    >
    > "Dave Peterson" wrote:
    >
    > > There are worksheet functions that are volatile. They recalculate whenever
    > > excel recalculates the workbook.
    > >
    > > Do you have functions like:
    > >
    > > AREAS()
    > > INDEX()
    > > OFFSET()
    > > CELL()
    > > INDIRECT()
    > > ROWS()
    > > COLUMNS()
    > > NOW()
    > > TODAY()
    > > RAND()
    > >
    > > And newer versions of excel like to recalculate older workbooks when they're
    > > opened. Then xl knows that the file is changed and prompts you accordingly.
    > >
    > >
    > > Alan wrote:
    > > >
    > > > Excel keeps asking to save unmodified files, very anoying after a while.
    > > >
    > > > Any Idea
    > > >
    > > > SP3 installed

    > >
    > > --
    > >
    > > Dave Peterson
    > >


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1