Excel 2010 on a 2008 R2 Terminal Server

Hi there,

We have just had to re-install office 2010 on our Terminal Servers as part of a rebuild processes.  Now what seems to be happening is all users's documents are being saved with the Author of the account that installed Office onto the terminal servers.

This is bad when a user has a document already open and if someone else opens the same document it then claims that the person who installed Office onto the terminal server has the file locked.  I've checked and can confirm that by default when a user loads excel it's setting the Author to the account that installed office.  

Has anyone come across this?  I found a hotfix to fix it but its already been applied.  Any help would be most welcome as always :)

Thanks
Jamie786Asked:
Who is Participating?

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

x
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.

[ fanpages ]IT Services ConsultantCommented:
"Has anyone come across this?"

I am presently using a Citrix VMWare-based environment on a client site (that provides access to a Windows Server 2008 R2 Standard operating system), & messages regarding "in use" files are exactly the same as the issue you described above.

However, the individual name of the user can be changed.

Here is the "Excel Options" window for MS-Excel 2007 (not MS-Excel 2010, as you are using, but the interface is similar):

MS-Excel 2007 - Excel OptionsMS-Excel 2007 - File in Use.jpg
Jamie786Author Commented:
Thanks, I've found that but this would involve all users changing this setting.  There is a registration key that can be reset to as I found here :-

http://www.geminimediaproductions.com/citrix_filelock.htm

and I can deploy this via a GPO to apply this but then every time a user opens Excel it asks for a user name and this is auto completed but users being users will moan at the extra click I'm sure :).... Is it possible to fix it on a Terminal server without the need to have a users interaction.
Mal OsborneAlpha GeekCommented:
My guess here is that the terminal server was not in install mode when Office was reinstalled. To install apps of a TS box, you need to switch to install mode, then back to execute mode once finished.

More on this here:
http://blogs.technet.com/b/perfguru/archive/2008/06/30/how-to-install-application-windows-2008-terminal-server.aspx

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
Jamie786Author Commented:
Ended up being the registry issue
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 Excel

From novice to tech pro — start learning today.