Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
AVCCTech
 
Posts: n/a
Default Excel 2k3: Workbook on network drive, when save creates new file

When we open up a shared workbook and enter data into it. Everything works
fine but once you save it the original still contains the information but in
the folder on the network drive that the original is located a new file is
created. This new file is the same size as the original document. It didn't
start doing this until it was moved from our old 2000 Server to our new 2k3
server. Can anyone help?
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Does that newly created workbook have a name of 8 characters (with no
extension)?

If yes...

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.

So maybe it's an Antivirus problem (can you disable it temporarily to check) or
maybe it's a network problem (talk to your IT folks.)

AVCCTech wrote:

When we open up a shared workbook and enter data into it. Everything works
fine but once you save it the original still contains the information but in
the folder on the network drive that the original is located a new file is
created. This new file is the same size as the original document. It didn't
start doing this until it was moved from our old 2000 Server to our new 2k3
server. Can anyone help?


--

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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Automatically save a copy of worksheet from C: to Network Drive doosbug Excel Discussion (Misc queries) 1 May 3rd 05 06:23 PM
Save? prompt when closing Excel MC Excel Discussion (Misc queries) 4 March 12th 05 10:55 PM
Excel workbook fails to display when selecting from my documents. 4jjgolly Excel Worksheet Functions 1 March 9th 05 12:48 AM
Excel workbook does not open in open window on desktop DeanH Excel Discussion (Misc queries) 2 March 8th 05 09:51 AM


All times are GMT +1. The time now is 03:06 AM.

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"