Thread: Saving in Excel
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
AC Helpdesk
 
Posts: n/a
Default Saving in Excel

I have 2 users that are experiencing this. When they open the file off of a
shared group network drive (they are one of 3 people that use the file) they
are NOT prompted that the file is in use. We checked and none of the other
users are using that file or even Excel. She goes to save her changes and she
is prompted with ..

"the file XXXXXX.xls may have been changed by another user since you last
saved it. In that case what do you want?"

options of "Save a copy" or "overwrite changes"

why are they getting this if no one has the file open??

"exceluserforeman" wrote:

I think you already have two instances of Excel open or the same workbook open.
Make sure you only have one instance open then you can overwrite the file,
also not "Save As" but "Save"


"Serenity2u" wrote:

When I click File, Save in Excel, the default choice is set as "Save as
Copy". I would like to change the default to "Overwrite Changes". How do I
do this?