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

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

Guest

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

Swisse
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel prompts to save when no changes made 2
How do I set up a file to automatically save on exit? 1
Auto save overwriting original copy 1
How do I get rid of prompt when saving Excel spreadsheet ? 1
Save changes? even when you've made none 3
Erroneous prompt when saving Excel files 1
How do I disable save prompt when exiting a sheet? 7
No "save changes" when exiting Excel 2003 3

Top