?
Solved

Office 2010, 10mb Excel file takes long to open

Posted on 2014-09-23
6
Medium Priority
?
362 Views
Last Modified: 2014-12-11
Excel 2010, 10mb file takes on average 57 seconds to open.....not just across the network, but also on the workstation that hosts the shared directory - seems like something isn't right correct?
0
Comment
Question by:teks14
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 56

Accepted Solution

by:
McKnife earned 1500 total points
ID: 40340956
I can give you some insight on common reasons for this, most probable ones first:
-anti virus software inspects too thoroughly or is buggy
-office is buggy and no patches are installed for office/windows ->install sp3 for office and all further updates. For windows, make sure to be on 8.1 update 1 if possible.
-file is somehow weird - try another excel file of a similar size. Also try your problem file on a clean windows with another excel version if possible or try open office' excel.
0
 

Author Comment

by:teks14
ID: 40364783
All Excel files take an unusually long time to open up - even on the machine that they are stored on....general file open time is about a minute.
0
 
LVL 56

Expert Comment

by:McKnife
ID: 40364790
Hmm. Why didn't you give feedback on those suggestions? Without, we cannot move on.
0
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 56

Expert Comment

by:McKnife
ID: 40493896
Could you solve it?
0
 

Author Comment

by:teks14
ID: 40493900
The file is 10mb, so I just chalked it up to files that size taking that long....other similarly sized files took the same time to open
0
 
LVL 56

Expert Comment

by:McKnife
ID: 40494874
You should not have given up. 57s for 10 MB is too much.
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

If you use NetMotion Mobility on your PC and plan to upgrade to Windows 10, it may not work unless you take these steps.
Detailed instructions on how to install an Access add-in in recent versions of Office and Windows (with screen shots)
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…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

764 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