Excel Freezes when Unhide / Hide sheets

bisel

Board Regular
Joined
Jan 4, 2010
Messages
159
This may have been answered before, but I cannot find a reference ...

I have opened a large workbook originally created in Excel 2003. And in Excel 2003 the hide / unhide sheet function works fine. But in Excel 2007 when I attempt to unhide or sheet, some of the sheets cause Excel 2007 to lock up that forces me to use task manager to end the application.

Does anyone have an idea on why this is occurring? How to fix the problem, etc.

Thanks,

Steve
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,352
Try saving the file in Excel 2007 format then opening that copy and using Hide/Unhide
 

ChadGuy

New Member
Joined
Apr 17, 2013
Messages
1
the save as wasn't an option for us. We were using .xlsm excel macro files and Office 2010. Since MS doesn't seem to wanna fix this issue we found a work around.

After you have the file open select 1 row, or 1 column then click the Home tab, and to the far right, click the little down arrow on Format.
Choose the row height(to unhide rows) or Column width(to unhide Columns) and set it to whatever number you need. this will unhide the items and shouldn't hang.
 

Forum statistics

Threads
1,136,331
Messages
5,675,156
Members
419,552
Latest member
jsanjur

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top