로그인
 
홈라이브러리학습다운로드지원커뮤니티포럼
Resources for IT Professionals >
> 
> 
excel 2010 - takes long time calculating spreadsheet

Răspuns excel 2010 - takes long time calculating spreadsheet

  • 2012년 8월 15일 수요일 오전 9:31
     
     
    로그인하여 투표
    0
    so far only 2 users seem to be affected - whenever they open 1 particular spreadsheet, it takes ages (5+ mins) to calculate something - not sure why this is happening. It's using 100% of the processor, one has an i5 with 4 cores the other user has a slower cpu with 2 cores but they both face the same issue 
     

모든 응답

  • 2012년 8월 15일 수요일 오후 3:26
     
     
    로그인하여 투표
    0

    I will throw some stuff out.

    Are you using vba code that runs on open?  You could try Application.ScreenUpdating = False and true around your code.

    Do the 2 people have some addons loading on open?  check that.

    You can try turning on manual calculation.  save.  close.  then reopen.  see if it is faster.

    You can try with no open excel at all.  See how long it takes to open.

    try with just excel open.  no other documents open.  then open the document.  see how long it takes.

     
  • 2012년 8월 16일 목요일 오전 5:04
     
     
    로그인하여 투표
    0

    check this link this may help you

    http://endorkins.com/2009/07/13/slow-excel-spreadsheet-try-this/

     
  • 2012년 8월 16일 목요일 오전 7:42
    중재자
     
     답변됨
    로그인하여 투표
    0

    Hi,

    Based on my research, the issue seems to be related to Internet Explorer 8 performing a search of network drives and your local area network and any disconnected network drives or LAN search issues will hang the loading of your Excel spreadsheet.

     

    Here is how to stop Excel 2010 from browsing your LAN / Network drives when you open an Excel spreadsheet on your local hard drive:

     

    1) Start Internet Explorer 8

     

    2) Go to "Tools" menu

     

    3) Go to "Internet Options"

     

    4) Go to "Security" tab

     

    5) Go to "Local Intranet"

     

    6) Click on "Sites" button

     

    7) Uncheck "Automatically detect intranet network"

     

    Now your Excel spreadsheet should open instantly.

    Jaynet Zhang

    TechNet Community Support