Excel creating temp files and then deleting the file


I have a user on our Windows network who is constantly having an issue.  The issue seems to involve only Excel files at this point.  When she goes to save an Excel file on the network, a temp file takes it's place and the file is gone.  I have seen a few posts on this, but I have not found a solution as of yet.  I am thinking of just uninstalling Office and reinstalling?

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

cheesebugahAuthor Commented:
She has just within the past week been getting "The document cannot be saved" box.  She closes the box and sometimes it prompts her to save, sometimes it doesn't.
Richard DanekeTrainerCommented:
First, please check her permissions on the network folder.  Ensure she has create, read, and write privileges.
cheesebugahAuthor Commented:
I checked her permissions.  She has full access.
Become a Leader in Data Analytics

Gain the power to turn raw data into better business decisions and outcomes in your industry. Transform your career future by earning your MS in Data Analytics. WGU’s MSDA program curriculum features IT certifications from Oracle and SAS.  

Does the issue occur when she saves to the local drive, network drive, replicated "My Doc's" folder, etc?  Issues with creating or modifying files may result from a problem with the destination disk array, SAN settings, etc.  Once you ID where the issues occurs, see if you can replicate the issue with your account.  And then you can check the logs for errors when you save/modify test files.  You may need to enable active logging or debugging to get detailed errors.  Then you can contact Miscrosoft or the server/SAN manufacturer, to see if you have a hardware/firmware problem.
cheesebugahAuthor Commented:
She is saving to a network share.  Nobody else in the entire company is having this issue.
Following your description, I would have virus scanners in my mind. If you can isolate it to one single user / machine, you may check the virus scanner settings as well I would check the machine for malware, which possibly slows down the machine and let run Excel into a timeout.

You may also check, if the user has the same problem using a different machine, just to find out, if it is a user or machine issue.

Make sure you installed the latest patches for office as well as for the virus scanners.

Another option you may check are the security settings in Excel (Options - Trust Center).  Dependent from the format of the file (creation version), Excel may possibly deny to write the file, but only an option if it happens regularly. So you may observe, if it happens typically with specific Excel files  or with any (even new) files.

Reinstalling Office is a fast shot, not the biggest effort, so an option to try out. But I don't really believe that it is Excel itself.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cheesebugahAuthor Commented:
I have uninstalled Office 2007 and upgraded her to Office 2010.  It has happened to the same Excel file twice now.  Hmmm...

I will double check the permissions on that file.
If it is connected to a file, you make take into your account, that also the file maybe damaged.
If there is a general problem, it would happen with any or most of the files
Also inspect the file size, as I said, for very large files the virus scanner can involve...
If it is just one Excel file, then you can try creating a new file, then copy the contents of each tab on the old file into the new file.  There may be a formatting error or corrupt portion of the original file that Excel can't detect or fix.
     If it is happening on multiple files, then have the user try editing this file while saving it to her local PC's disk or a different server/share.
cheesebugahAuthor Commented:

Are you talking about the actual size of the file or the length of the path to the file on the network?
;-) I originally meant the size of the file, but as you said it now, also a possibility is the path length.
Usually newer programs should be able deal with long path / file names, but possibly not every program. But easy to check...
You can try so save the same file under a shorter path / file name and see if the problem persists.
You can save the file somewhere else to see if the problem persists. An even you can save the file on the same location under a new (long) name to check.

All the time close excel and reopen it before you test another file / location.

Dependent on the results, you can narrow down a possible cause.
cheesebugahAuthor Commented:
Since the upgrade to 2010, this has not happened again.  I am closing this issue.  All of the suggestions provided here have helped tremendously in troublehooting.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Network Operations

From novice to tech pro — start learning today.