I made the mistake of hiding all additional rows and columns in my workbook thinking it would make the workbook run faster since it wouldn't need to worry about the additional rows/columns. This has slowed down my workbook heavily. I'm trying to go back and unhide all these rows/columns to hopefully speed my workbook up, but every time I click unhide on the rows excel crashes. I have tried simply unhiding from the page, turning off calculations then unhiding, I have tried clicking home>format>hide & unhide>rows, I've tried multiple different macros including clearing formats before unhiding.
All my macros use an optimization code before hand that says:
"Application.ScreenUpdating = False
EventState = Application.EnableEvents
Application.EnableEvents = False
CalcState = Application.Calculation
Application.Calculation = xlCalculationManual
PageBreakState = ActiveSheet.DisplayPageBreaks
ActiveSheet.DisplayPageBreaks = False"
I have put days worth of time into this spreadsheet and it seems to be essentially broken now. It will still work just extremely slow thanks to the hidden rows and columns. If anyone could help, you would be a life-saver!
EDIT: Found a solution. I just made 5 different macros to space out unhiding the rows in several chunks rather than all at once.
Bookmarks