Solved

Excel 2010 takes an extremely long time to open attachments

Posted on 2011-02-17
14
1,339 Views
Last Modified: 2012-05-11
We have recently upgraded to Exchange 2010 and office 2010 statndard on all of our workstations (XP Pro sp3). I have 1 user that is experiencing extremely long wait times (10 minutes) to open any attachments that are Word or Excel files. If they save the attachment to their desktop, it opens normally. Likewise I had the user forward the attachments to me, they opened normally directly from Outlook. I have tried every reasonalble solution I can find on Google. Changed the DDE settings, etc. I have also tried un-installing Office & re-installing it. No change. I am stumped. I may be forced to re-image the PC and start from scratch. I would prefer a less drastic solution.
Thanks in advance for any ideas you may have.
0
Comment
Question by:spikesound
  • 5
  • 3
  • 2
  • +3
14 Comments
 
LVL 3

Expert Comment

by:goldeneagle3333
Comment Utility
What anti virus is on the slow computer?  You might try to disable the Anti Virus and then try opening the document.  
0
 

Author Comment

by:spikesound
Comment Utility
We use Trend Micro Office Scan. I did try that without success. Thanks.
0
 
LVL 3

Expert Comment

by:goldeneagle3333
Comment Utility
What does it do if you open the attachment from outlook web app?  
0
 

Author Comment

by:spikesound
Comment Utility
I haven't tried that. I called the user. She is off until Tuesday. I will try that then. Thanks again.
0
 
LVL 7

Expert Comment

by:Forror
Comment Utility
open explorer -> Tools -> Folder Options -> File Types

got to the .XLS + XLSX?? extension click Advanced select the bold action -> Edit and
in the box under "Application used..." go to the end and add the "%1" after
the /e

so for the .XLSX Extensions Open command this becomes "<Installation
Folder>\Microsoft Office\Office14\EXCEL.EXE" /e "%1"

When it's the new action it should be "<Installation Folder>\EXCEL.EXE /e
"%1" /n
0
 
LVL 14

Expert Comment

by:Don Thomson
Comment Utility
How much Ram is on the Machine?
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 

Author Comment

by:spikesound
Comment Utility
1 GB. I have other machines with identical specs or lower that are not experiencing this issue.
0
 
LVL 19

Expert Comment

by:akoster
Comment Utility
have you tried to find out what is taking the computer so long, if it is stalling due to 100% CPU usage or large memory usage or large file IO usage ?
The easiest way to investigate this is to open the processes tab on the task manager. Using the menu you can select the visible columns, make sure that the I/O : read bytes and I/O : written bytes columns are selected.

at least you know now what is causing the large delay.
look at the process that consumes the cpu cycles, is it outlook / word / excel / virus scanner or other ? any macro's that are automatically running ?

also, investigate the computer's system log files to indicate if any relevant log entries have been made.
0
 
LVL 14

Expert Comment

by:Don Thomson
Comment Utility
Have you tried going through and disabling the Add-in in outlook one at a time - Restart Outlook after each one and see what happens. If nothing changes - enable the last one you disabled and try disabling the next one.

Lat timne I had this problem it had something to do with a stupid I-Tunes add-in
0
 

Author Comment

by:spikesound
Comment Utility
OK. I have had an opportunity to work on this issue again. The attachments open properly for Outlook web access. Forror changes caused Excel to stop functioning. I had to use system restore to undo those changes. I tried disabling all the outlook add-ins. No change. The cpu is not showing any high usage during the opening process.
0
 
LVL 14

Expert Comment

by:Don Thomson
Comment Utility
you may want to have a look through the add or remove programs and see if anything stands out as something that shouldn't be there.

The next thing to do would be get the machine that is having the problem and a similar machine with the same amount of memory in it

Restart them both - let everything load then go to task manager and see what the ram usage is on each - It could be someting as simple as the video card on the ones that are working have their own memory and this one uses shared memory - 1 Gig today especially with Office 2007 or 2010 is not considered very much - 2 or 3 would be much better if they intend to have more than 1 program running at a time
0
 

Accepted Solution

by:
spikesound earned 0 total points
Comment Utility
We got it!!!. One of my colleages took a shot at it. He ran CCleaner and the issue went away. Thanks to everyone for your assistance.
0
 
LVL 24

Expert Comment

by:broomee9
Comment Utility
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now