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?
 
celticsConnect With a Mentor Commented:
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
 
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
All Courses

From novice to tech pro — start learning today.