Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
SJS SJS is offline
external usenet poster
 
Posts: 20
Default User replaces existing file with blank during file open

I have a couple of users that are constantly overwriting a workbook on the
network with a blank copy of the same name. They say when they do file open
and open the file they get a message that the file exists do they want to
replace and if they say yes it overwrites the good copy with a blank. I have
them set to not use offline line files but that didn't stop the problem.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default User replaces existing file with blank during file open

Just a guess...

But it sounds like they're hitting File|SaveAs instead of File|Open.

This would pretty farfetched--is there a chance that someone modified their
toolbar so that file|Open does the wrong thing?

Do they see "Save As" or "Open" in the titlebar of that dialog?

sjs wrote:

I have a couple of users that are constantly overwriting a workbook on the
network with a blank copy of the same name. They say when they do file open
and open the file they get a message that the file exists do they want to
replace and if they say yes it overwrites the good copy with a blank. I have
them set to not use offline line files but that didn't stop the problem.


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
SJS SJS is offline
external usenet poster
 
Posts: 20
Default User replaces existing file with blank during file open

well you know anything is possible and that's probably as best of a guess as
there is. I'll have them start only using the file open option instead of
toolbar icons. Thanks

"Dave Peterson" wrote:

Just a guess...

But it sounds like they're hitting File|SaveAs instead of File|Open.

This would pretty farfetched--is there a chance that someone modified their
toolbar so that file|Open does the wrong thing?

Do they see "Save As" or "Open" in the titlebar of that dialog?

sjs wrote:

I have a couple of users that are constantly overwriting a workbook on the
network with a blank copy of the same name. They say when they do file open
and open the file they get a message that the file exists do they want to
replace and if they say yes it overwrites the good copy with a blank. I have
them set to not use offline line files but that didn't stop the problem.


--

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default User replaces existing file with blank during file open

Maybe you can wander over (if you're in the same facility) and watch them do it
a few times.

If they're using toolbar icons, maybe they're hitting the wrong items???

sjs wrote:

well you know anything is possible and that's probably as best of a guess as
there is. I'll have them start only using the file open option instead of
toolbar icons. Thanks

"Dave Peterson" wrote:

Just a guess...

But it sounds like they're hitting File|SaveAs instead of File|Open.

This would pretty farfetched--is there a chance that someone modified their
toolbar so that file|Open does the wrong thing?

Do they see "Save As" or "Open" in the titlebar of that dialog?

sjs wrote:

I have a couple of users that are constantly overwriting a workbook on the
network with a blank copy of the same name. They say when they do file open
and open the file they get a message that the file exists do they want to
replace and if they say yes it overwrites the good copy with a blank. I have
them set to not use offline line files but that didn't stop the problem.


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
why does more than one file open when i open existing XLS file Mark Excel Discussion (Misc queries) 0 October 12th 07 11:10 PM
cannot open an existing file in excel 2003 chughes Excel Discussion (Misc queries) 3 March 2nd 07 12:46 PM
File is already open by user X eagle13 Excel Discussion (Misc queries) 1 July 24th 06 01:14 PM
Can't open existing file LisaK Excel Discussion (Misc queries) 3 April 18th 06 10:14 PM
Open existing Excel file Bill Coupe Excel Discussion (Misc queries) 3 January 18th 05 07:53 PM


All times are GMT +1. The time now is 01:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"