Slow Excel Sheets

I have written quite a lot of VBA on an excel sheet.  It takes about 30 secs to open up and even longer to save the sheet.

What can I do to speed this up?
bezalelyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

celticsCommented:
Remove the empty cells from the spreadsheet.  If you hit the <End> key and then the <Home> key it will take you to the last row and column that Excel thinks exist in you spreadsheet.  Compare this with where your data actually ends in columns and rows.  I.E.  if it takes you to AA1020 and you have data in column AA but only have data up to row 980 in column Z(AA ends at 979) then you have wasted space.  The only way I know how to remove this space is to Insert a new sheet in your workbook and copy and paste the cells with information(in this case A1 to AA980) from the old sheet to the new one.  Once this is done delete the old sheet and rename the new one to the old ones name and save the workbook.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bezalelyAuthor Commented:
cheers mate! you're a genius.  It's been bugging me for weeks,

thank you, thank you, thank you!
0
celticsCommented:
No, not a genius, I went through the same BS with Excel already.  Glad to be of help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Hardware

From novice to tech pro — start learning today.