Excel only opens correctly when zoom is set to 100%

[PAHguy]

Hi guys,

I hope someone can help with this. This is the most bizarre thing I've ever encountered in excel. So, basically, when I save my excel sheet with the zoom at anything other than 100%, then close it, then reopen it, it opens with these weird blocks of gray in the excel sheet (blocks of gray bars that appear across the cells). I've attached an image - the blocks of gray vary by where they appear each time though. By clicking zoom in or out just once, it fixes it. The only way it opens without all the gray blocks in the sheet is if it has been saved at zoom 100% and then opened.

There is a second thing I've noticed. If I unfreeze all pains, this issue does not occur, meaning I can save at any zoom level and it'll open fine. This issue only occurs when panes are frozen.

Obviously, I can still use my excel sheet, but these things are a pain, especially since others use the excel sheet too.

This only started happening 2 days ago. Any advice on what to try to solve this would be greatly appreciated. Thank you so much.

 

[PAHguy]

Bump - any ideas? I tried this in a new excel sheet that I created and the same thing happened. Freeze panes - issues if not at 100% zoom. Unfrozen panes - fine at all zooms.

 

[jls9874]

Something like what you described is happening to me tonight, too. The grayed-out areas and opening at odd places on the sheet. My sheets are opening anywhere but where I was when I last saved the workbook. This is happening to single sheets and to every sheet in multi-sheet workbooks. Even stranger; moving the mouse cursor to a cell with data, the "box" cell guide is 4 cols to the left! Oh, and the fonts are much smaller and a new (empty) column "A" has been added.

I suspect this is due to a 365 update in the past few days. I didn't use Excel the past 5-6 days, but it certainly wasn't doing these crazy things early last week. I've been fussing with it for hours, finally posted a question on the net, and found your post, *PAHguy. I hadn't even thought about zoom involvement; you might be on to something there (almost all my sheets are set at 135).

I've been using Excel and earlier spreadsheet programs for some 30 years (I was a small biz bookkeeper). Most of the weird spreadsheet behaviors I've seen have been due to half-baked program updates.

 

[mofouad]

Something like what you described is happening to me tonight, too. The grayed-out areas and opening at odd places on the sheet. My sheets are opening anywhere but where I was when I last saved the workbook. This is happening to single sheets and to every sheet in multi-sheet workbooks. Even stranger; moving the mouse cursor to a cell with data, the "box" cell guide is 4 cols to the left! Oh, and the fonts are much smaller and a new (empty) column "A" has been added.

I suspect this is due to a 365 update in the past few days. I didn't use Excel the past 5-6 days, but it certainly wasn't doing these crazy things early last week. I've been fussing with it for hours, finally posted a question on the net, and found your post, *PAHguy. I hadn't even thought about zoom involvement; you might be on to something there (almost all my sheets are set at 135).

I've been using Excel and earlier spreadsheet programs for some 30 years (I was a small biz bookkeeper). Most of the weird spreadsheet behaviors I've seen have been due to half-baked program updates.

I apologize for my delayed response, but it took me some time to find a solution for this issue. I wanted to share the fix with you.

I noticed that the issue arises when an Excel workbook contains multiple sheets with varying zoom levels. By setting the same zoom level for all sheets, the problem was resolved in my case.

I hope this helps! Please let me know if you need further assistance.