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.
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\Micr osoft\Wind ows\Tempor ary Internet Files\Content.Outlook\xxxx xxxx
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
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\
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
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.
ASKER
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.
ASKER
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.
ASKER
So I did disable the anti-virus and the problem is still happening.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.