Thanks for the advice.I didn't create this sheet and others use this sheet on
their computer as well and don't get the prompt.Thats why I am stumped with
this.

"JLatham" wrote:

Just use File | Save rather than File | Save As to 'update' a file with
latest changes in it.
The prompt is caused by Excel noting that you've used the Save As option and
it's trying to protect you from yourself. And to keep you from being one of
those people who later comes here posting "HELP! I overwrote a file with a
different file, how do I get my original file back?" type of thing.

If you're using File | Save As to save into a backup location then you're
going to get the prompt each time you try to save into a different location
where a file with that name exists.

If you were doing the save from within VBA code and didn't want the user to
be nagged you could inhibitors to the prompt:
Sub JustOverwriteIt()
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:="M:\FileToSave.xls"
Application.DisplayAlerts = True
End Sub


"Jenn" wrote:

how do i get rid of this prompt?is it something in excel or in my windows
folder?
my sheets should automatically overwrite changes to a worksheet.