Solved

opening excel application with new workbook very slow

Posted on 2014-03-23
5
442 Views
Last Modified: 2014-04-07
hey guys, i'm sorry to ask this super open ended question, but suddenly when i open the excel application (not a workbook), it takes like 10 seconds to open. even after restarting my computer.

i can understand if i'm opening a workbook and it has external links etc, but this is a purely blank excel workbook that the excel application creates each time it is opened.

could yall suggest some tips / a workflow troubleshooting list that i can apply to my excel? thanks guys!!
0
Comment
Question by:developingprogrammer
  • 2
  • 2
5 Comments
 
LVL 10

Accepted Solution

by:
Scott Thomson earned 250 total points
ID: 39949535
On startup Excel loads templates and printers. Are there any issues with any printers on that machine or mapped network drives?

Is this only occuring on the 1 machine..?
Disconnect all network drives (barring the essentials) and try again

Also remove all printers and try again
0
 
LVL 16

Assisted Solution

by:gurutc
gurutc earned 250 total points
ID: 39950105
Hi,

It could also be excel validating previous documents.  Have you cleared that too?  What version of Excel?  

Also see if the Office File Validation Add-in is installed.  If so, try removing it.

- gurutc
0
 

Author Comment

by:developingprogrammer
ID: 39984901
hi guys, thanks for your help! and i'm sorry for the slow reply!

hi Scott, whao i didn't know Excel does all that in the background! yup i did as per what you said but instead of disconnecting the printers i went to a different office and rebooted my computer. strangely that did the trick - i'm not sure why.

hi gurutc, whao i never knew about Excel validating previous documents. i went to read up a bit more about that and have a better understanding now. i didn't remove the Office File Validation Add-in so i don't think that was the issue but all the same, thanks for your help and sharing! = )
0
 
LVL 10

Expert Comment

by:Scott Thomson
ID: 39984912
yeah I actually read up on office validation also. basically anything pre 2003 can cause issues with slow performance especially on a network.. who knew :)

But happy you got the issue sorted out developingprogrammer

That's why we are here as a community
0
 

Author Comment

by:developingprogrammer
ID: 39984916
= ) that's right Scott! = ))
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

910 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now