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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top