Workbook causes Excel to Lock-up.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been developing the workbook in question for quite some time now and it has never given me any problems. It is only recently that it causes excel to lock-up when opening it. The status bar in the bottom left corner will go halfway through the open process after which Excel will lock-up

The same thing happens when opening it on another pc

It seems like every time I add bulk information on it like a additional Table or Sheet and save it Excel will not open it.
 
I have found the reason why the specific workbook did not open after I saved it.

On one of the sheets I have hidden all the rows beyond Row number 100 because it looked neat and prevented anyone from entering data into these cells. The problem that occurred with this was that when I selected cells up to row 100 for putting a border around I did not pay attention to the fact that it was actually selecting all the rows up to row number 65439. The problems then was when saving the workbook it would not open again. This was probably caused due to a overload of data
 
Back
Top