Excel reports "Unable to save document. A temporary file named xxx has been created"

Hi

We have two users on our Windows SBS 2003 network that are running Excel 2000 (one of which on Vista, one on Windows XP SP2).

They are experiencing an intermittent problem when opening xls files from their My Documents folder and then saving a modified version to the server.

Excel displays the error message "Unable to save document. A temporary file named xxxxxx has been created" where xxxxxx is a number.  The temporary file can be renamed with .xls appended and opened.

I suspect it is a problem with the synchronisation of the redirected My Documents folder but don't know why this has started happening.  The file permissions appear to be correct when I look at the files.

NTBackup was running this morning but as it uses shadow copies I don't think that would cause it.

Has anyone else encountered this problem and know what the solution is?  We cannot upgrade from 2000 at the moment as Act! 2007 is not compatible with later versions.

Many thanks
Graham
itcgroupAsked:
Who is Participating?
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.

ExcelGuideConsultantCommented:
It seems like they are working with the file at the same time? If so, they need to share their workbook so two ppl or more can work at the same time.

Good luck
0
war1Commented:
Hello itcgroup,

Also, any Office 2000 programs, including Excel 2000, is not designed to work on Vista.  You need Office 2003 or 2007 to work on Vista.

Hope this helps!
war1
0
itcgroupAuthor Commented:
Hello Psychotec

I don't think the xls file has been opened by someone else as it is in the user's Documents folder and they have not shared it.  I have however asked them if they could have opened the same xls file twice.

War1 - we have had Office 2000 running on a few Vista PCs without any more problems than on XP.  I'm sure that MS would rather they were upgraded but it does the job, apart from this one problem in Excel which we can workaround by moving the xls files from the My Docs folder to a folder on the server.

Thanks guys for your suggestions.  I am waiting to see if the problem happens again for more details.

Regards
Graham
0

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
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
Microsoft Applications

From novice to tech pro — start learning today.