Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / December 2007

Tip: Looking for answers? Try searching our database.

Trouble Saving

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Libby - 07 Dec 2007 18:15 GMT
Hi

There is an Excel spreadsheet that is kept on a network drive. It was
orginally created in Excel 2000 but is saved by users using Excel 2003.  Most
people experience no problems, but I have this problem when I save it:

Every time I save it a new file is created in the folder where the
spreadsheet is kept. This file appears to be a copy of the spreadsheet, but
it has a Windows logo icon and a seemingly random alpha-numeric file name
such as ABDF2003
There are macros in this spreadsheet that save it at certain stages and this
results in a large number of these strange files being generated.

I only get these files when saving to the folder on the network. Saving
elsewhere doesn't produce these files.

Does anyone know why this is happening and how to stop it?

Many thanks in advance.

Libby x
Dave Peterson - 07 Dec 2007 08:46 GMT
When excel saves the file, it saves it as a temporary file with a funny name (8
characters--no extension) in the same folder.  

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.

If you're seeing that funny named file, then something is going wrong.

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.

> Hi
>
[quoted text clipped - 17 lines]
>
> Libby x

Signature

Dave Peterson


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.