Solved

Excel 2010 takes an extremely long time to open attachments

Posted on 2011-02-17
14
1,365 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
ID: 34916456
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
ID: 34916512
We use Trend Micro Office Scan. I did try that without success. Thanks.
0
 
LVL 3

Expert Comment

by:goldeneagle3333
ID: 34916610
What does it do if you open the attachment from outlook web app?  
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

Author Comment

by:spikesound
ID: 34916646
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
ID: 34916755
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
ID: 34916842
How much Ram is on the Machine?
0
 

Author Comment

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

Expert Comment

by:akoster
ID: 34917001
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
ID: 34917038
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
ID: 34972859
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
ID: 34973032
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
ID: 35001496
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
ID: 35225326
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Outlook Free & Paid Tools
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

840 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