Citrix Excel - Problem Opening File from Outlook

One of our users recently started having problems opening Excel files from Outlook (Citrix not local).  It only seems to be Excel, other attachments work fine (Access, PowerPoint etc).  Also its any Excel file from Outlook, not just one specific file.  I asked him to save a copy of an Excel file to his desktop and he was able to open the file without problems.  I'm not able to figure out what the problem is at this point.
Who is Participating?
Craig RoberdsConnect With a Mentor MISCommented:
I would try this first logged in as that user:

If not, since it is one user it could be the user profile is corrupted somehow (chances are user changed something somewhere).  

If the KB article doesn't work post what versions of Office and citrix you have.
GlennaShawConnect With a Mentor Commented:
I'd check the file associations on the Citrix server and make sure the excel ones are correct.  The easiest thing to do would be to run Excel and select Help, Detect and Repair.
aloyd18Author Commented:
I run Citrix 4.0 with Office 2007, I cant seem to find the diagnostics in the menu options and I cant get to it locally from the start menu.
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

From within Excel, click on the Office Button, click Excel Options, click Resources, click Check for Updates if you haven't installed SP1 or click Diagnose if you have installed SP1.
Craig RoberdsMISCommented:
Try what Glenna has said but from that user's account while in citrix (or while shadowing them).

Glenna do you know where excel keeps it's user settings at?  Is it in the Documents and Settings\%username%\Application Data\Microsoft\Office folder?  If it is then perhaps they can delete or move the correct file or folder and logout and logon back in so it will go back the default settings.  Since it is only one user chances are they made a change while in a user session or the file became corrupt.

I would think the change happened in Excel but it could have happened in Outlook since that is where the issue is.

If it was me I would just move the users entire TS profile to a backup folder and let them login again-which will give them all the default settings.  But this also assumes that you have a basic setup where they don't keep files in their My Documents on the citrix server and that their email is on the email server and not a .pst, etc.  If they access IE through citrix you will have to move all of their favorites back as well.  Sometimes that is easier than trying to find the corrupt file or the check box the user inadvertently clicked.
aloyd18Author Commented:
Ended up that the user change the "ignore other applications that use dynamic data exchange" option.  You're advice pointed me in the right direction to find the right answer.  Thanks
Solution works great!

To resolve this problem, follow these steps:

Close the e-mail message.
Start Excel.
On the Tools menu, click Options.
Under the General tab, click to clear, Ignore other applications, and then click OK.
Quit Excel.
All Courses

From novice to tech pro — start learning today.