2012년 8월 15일 수요일 오전 9:31so 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
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
check this link this may help you
2012년 8월 16일 목요일 오전 7:42중재자
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.
TechNet Community Support
- 답변으로 표시됨 Jaynet ZhangMicrosoft Contingent Staff, Moderator 2012년 8월 20일 월요일 오전 2:29