Saving changes creates unopenable file.

G

Guest

I have several users that use Excel 2003 on a regular basis. Some o fthese
users are reporting that when they open an existing excel workbook and make
changes, the application closes and creates a file in the original folder
that housed the original workbook. The file that is created is a random
string of numbers with no extension that I can find, this file cannot be
opened using any application (Word, Notepad, Excel) however I can open and
repair the file from excel but the formulas and formatting are gone so I do
not know if the changes made were saved. I have re-imaged the problem
machine, uninstalled and reinstalled excel with no success in solving the
problem. The issue seems to happen to random machines and random workbooks.
It doesn't matter whether the book is located on a network or local drive.
Does anyone have any ideas why this is happening?
 
N

Nick Hodge

Frank

This normally happen when something interrupts a save. Excel saves the
workbook to a copy with the random name and then renames it when the save is
complete and deletes the original.

AV software can sometimes cause this or code (add-ins) which is monitoring
and save

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
 
G

Guest

I already tried stopping the anti-virus services to see if it woul dfix the
issue no such luck. I will have a look and see if there are any add-ins that
may be causin gthe problem though.

Thanks
 
G

Guest

Further to this problem, I have checked to see what Add-Ins were runnign on
the user's machine and there were none. The problem only seems to be
occurring with files on a network share.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recover an unopenable file 3
Excel File loses .xls extension and file Name changes 1
Shared workbook - loss of connection at save 1
Shared Workbook Saving Issue 1
Excel changes file extension on embedded object upon save 1
Cannot open a file I just saved 2
Excel Changes Not Saving - Excel 0
Migrating from 2003 to 2007: Unexpected link errors appear 3

Top