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?

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

Swisse

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"
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?