Office 2010, 10mb Excel file takes long to open

Posted on 2014-09-23
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?
Question by:teks14
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
LVL 54

Accepted Solution

McKnife earned 500 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.

Author Comment

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.
LVL 54

Expert Comment

ID: 40364790
Hmm. Why didn't you give feedback on those suggestions? Without, we cannot move on.
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

LVL 54

Expert Comment

ID: 40493896
Could you solve it?

Author Comment

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
LVL 54

Expert Comment

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

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

730 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