+ Reply to Thread
Results 1 to 3 of 3

When I save a file I consistently get a message about saving a co.

  1. #1
    cynspin
    Guest

    When I save a file I consistently get a message about saving a co.

    When I save an Excel file on my new XP machine, I am always prompted to
    answer a question saying my file may have been overwritten by another user,
    do I want to save a copy or overwrite changes. I want to automatically
    overwite - even though nobody else is accessing the file.... Can I disable
    this warning?

  2. #2
    swisse
    Guest

    RE: When I save a file I consistently get a message about saving a co.

    In Workbook_BeforeSave() write:
    Application.DisplayAlerts = False
    and in Workbook_BeforeClose() write:
    Application.DisplayAlerts = True

    Swisse

  3. #3
    Gord Dibben
    Guest

    Re: When I save a file I consistently get a message about saving a co.

    cyn

    Have a look at this KB Article

    "The file may have been changed..." error when you save work¬*book to network
    server in Excel 2002

    http://support.microsoft.com/default.aspx?kbid=324491

    Myrna Larson also reported that she got this error when open¬*ing a workspace
    (*.xlw) file.

    Opening the workbooks individually solved the problem.


    Gord Dibben Excel MVP




    On Tue, 1 Feb 2005 11:51:03 -0800, "cynspin"
    <cynspin@discussions.microsoft.com> wrote:

    >When I save an Excel file on my new XP machine, I am always prompted to
    >answer a question saying my file may have been overwritten by another user,
    >do I want to save a copy or overwrite changes. I want to automatically
    >overwite - even though nobody else is accessing the file.... Can I disable
    >this warning?



+ 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