Link to home
Start Free TrialLog in
Avatar of GSchaffer233
GSchaffer233

asked on

Outlook 2007 Attachment Problem

I have a user who has a problem opening Excel spreadsheets in Outlook. When you open the attachment from Outlook, it opens up Excel, but the spreadsheet doesn't open up. The work around for the moment is to save the attachment to the desktop and then open it, but clearly this is not a true solution. Has anyone else seen this? Thanks.
Avatar of Rob Hutchinson
Rob Hutchinson
Flag of United States of America image

Probably the macro security settings in Excel...try setting to the lowest security setting, and then see what happens when you open in Outlook.
Hello GSchaffer233,

The Outlook folder where attachment opens may be full. Clear the files from Outlook cache folder OLKxx.  This folder is difficult to access. Here is a way to access the folder and files
http://www.outlook-tips.net/archives/2003/20030828.htm

In Vista, the Secure Temp folder is located at C:\Users\username\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\xxxxxxxx

Outlook Temp Cleaner to find and clean OLK folder
http://www.howto-outlook.com/products/outlooktempcleaner.htm
OR
Batch file to clean OLK folder
http://www.howto-outlook.com/products/outlooktempcleaner.htm


Hope this helps!
war1
Avatar of GSchaffer233
GSchaffer233

ASKER

Thanks for the attempts WiReDNeT and war1, but neither of those worked. The Outlook temp directory was only 2mb, but I cleared it anyway, closed Outlook and Excel, opened them back up, and it still did the same thing.
Is the Excel sheet xls or xlsx extension?  Associate the extension with Excel program in File Types.  In Windows Explorer or any folder, go to Tools > Folder Options > File Types. Scroll down to xlsx and highlight.  Select Microsoft Excel as the program to use to open this extension.  Click OK. Restart the browser.
I haven't seen it happen with xslx, but it is happening for sure with xls. I have checked to make sure xls and xlsx are associated correctly.
Does the problem XLS attachment have a macro?  An antivirus virus or another security program running in the background could be blocking executable attachment.
No macro, I created an XLS document and sent it to the user to test out. I was told about this problem over a month ago and have not had time until recently to look into it. During that time our firm has switched to a different antivirus product, so it seems unlikely that is the case, however I will disable and give it a try.
So I did disable the anti-virus and the problem is still happening.
ASKER CERTIFIED SOLUTION
Avatar of GSchaffer233
GSchaffer233

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial