Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Brian Doc
 
Posts: n/a
Default Duplicate Files Created

Have a user who is working on a spreadsheet.
When she saves her changes, and exits out of the spreadsheet, it creates a
duplicate file. It is an unassociated file, but it does open with Excel.


  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Are you sure it's an exact duplicate???

When excel saves the file, it saves it as a temporary file with a funny name (8
characters--no extension).

If the save is successful, xl will delete the original (or rename it to its
backup name (like "backup of book1.xlk)) and if that's successful, xl will
rename the funny named file to the original's name.

Common things that get blamed for interruptions to this process are antivirus
software poking its head in or network errors--either permissions or physical
problems.

Maybe temporarily disabling the antivirus software would be the easier thing to
test. If that doesn't help, maybe there was a permissions change???

Brian Doc wrote:

Have a user who is working on a spreadsheet.
When she saves her changes, and exits out of the spreadsheet, it creates a
duplicate file. It is an unassociated file, but it does open with Excel.


--

Dave Peterson
  #3   Report Post  
Brian Doc
 
Posts: n/a
Default

It is an exact duplicate.
The temp file is being created, but the original file is not being affected.
It is not being renamed.

Cannot disable AntiVirus as this is on a network share, and cannot risk
something getting in...

The permissions for this file are currently being looked at by the Network
Admin.

Thanks for your response.

"Dave Peterson" wrote:

Are you sure it's an exact duplicate???

When excel saves the file, it saves it as a temporary file with a funny name (8
characters--no extension).

If the save is successful, xl will delete the original (or rename it to its
backup name (like "backup of book1.xlk)) and if that's successful, xl will
rename the funny named file to the original's name.

Common things that get blamed for interruptions to this process are antivirus
software poking its head in or network errors--either permissions or physical
problems.

Maybe temporarily disabling the antivirus software would be the easier thing to
test. If that doesn't help, maybe there was a permissions change???

Brian Doc wrote:

Have a user who is working on a spreadsheet.
When she saves her changes, and exits out of the spreadsheet, it creates a
duplicate file. It is an unassociated file, but it does open with Excel.


--

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 do I have duplicate excel files - name:1 [vsync], name:2 [vsy harry38 Excel Discussion (Misc queries) 2 January 19th 07 09:16 PM
FILES CREATED AUTOMATICALLY WHILE SAVING Venoy Varghese P Excel Discussion (Misc queries) 0 March 30th 05 05:01 PM
How to disable the shortcuts of excel files created by MSExcel 20. Nikhil Excel Discussion (Misc queries) 1 February 19th 05 01:40 PM
Created Excel files are read-only Bales Excel Discussion (Misc queries) 2 January 4th 05 06:55 PM
Multiple Files, Duplicate Entries PMSunshine77 Excel Discussion (Misc queries) 1 December 10th 04 09:28 PM


All times are GMT +1. The time now is 05:13 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"