Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I've got a relatively small (~100K) Excel 2010 spreadsheet that (via VBA) when opened, closes all worksheets except the start page, checks the user name and cross checks it with a SQL table, bringing back the user's record to check their permissions.

A few cells are updated rangeUserName, rangeCurrentUser, rangeSystemAccess etc...

If I open this workbook when there are other large spreadsheets (that also have vba), it takes about 30 to 60 seconds to open, when if no other workbooks are open, it takes under 5 seconds.

Why is this?

share|improve this question
    
Does this happen again if you (re-)save the file after you opened it ? I had a similar issue once and got it solved by reading: excel2007-slow-open-file.blogspot.nl –  HerbalMart Aug 22 '12 at 13:07
    
Yes it does happen if I resave it after I open it and I don't think it relates to that. –  aSystemOverload Aug 22 '12 at 18:59
    
Do you know where in the VBA it stalls? –  CharlieRB Aug 22 '12 at 19:41
2  
This should not have been migrated from stack overflow given it is VBA related –  brettdj Aug 23 '12 at 2:17
    
Check the on open macro to see what it is doing, it seems this is the problem? –  enderland Aug 24 '12 at 11:18
show 2 more comments

migrated from stackoverflow.com Aug 22 '12 at 13:01

This question came from our site for professional and enthusiast programmers.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.