The Excel "Grey Block On The Left Side" issue

Not related to a specific OLAP tool. (Includes forum policies and rules).
Post Reply
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

The Excel "Grey Block On The Left Side" issue

Post by Alan Kirk »

This is one that seems to appear intermittently; I've never been able to find the cause of it, much less a solution other than kicking over Excel and restarting it.

Occasionally a large grey block appears on the left hand side of the worksheet window, below the formula bar and name bar and extending to the status bar. It isn't tied to any individual worksheet window; you can resize or pane to your heart's content and it just won't budge.

The Grey Block Of Doom is illustrated in the attachment.

Does anyone know of a way of preventing / fixing this other than a restart of Excel?
BlockOfDoom.jpg
BlockOfDoom.jpg (49.97 KiB) Viewed 10659 times
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
User avatar
John Hobson
Site Admin
Posts: 330
Joined: Sun May 11, 2008 4:58 pm
OLAP Product: Any
Version: 1.0
Excel Version: 2020
Location: Lytham UK
Contact:

Re: The Excel "Grey Block On The Left Side" issue

Post by John Hobson »

Alan

I have never experienced the Grey Block of Doom, but it looks remarkably similar to the Blue Block of Demo Death (same position and size) that I got whenever I tried to show ISB to a prospective client.

("Look! You can dice and slice in the spreadsheet itself - oooh now isn't THAT a great visual effect, and so BLUE! Now let's have a little chat about your requirements whilst I reboot, shall we?")

Of course it can't be the same thing as I was assured that "nobody else has ever had this problem" :lol:

You wouldn't be playing with that particular nest of bugs would you?
John Hobson
The Planning Factory
User avatar
Steve Vincent
Site Admin
Posts: 1054
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: The Excel "Grey Block On The Left Side" issue

Post by Steve Vincent »

Can't say it's ever happened to me...
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: The Excel "Grey Block On The Left Side" issue

Post by Alan Kirk »

John Hobson wrote:Alan

I have never experienced the Grey Block of Doom, but it looks remarkably similar to the Blue Block of Demo Death (same position and size) that I got whenever I tried to show ISB to a prospective client.

("Look! You can dice and slice in the spreadsheet itself - oooh now isn't THAT a great visual effect, and so BLUE! Now let's have a little chat about your requirements whilst I reboot, shall we?")

Of course it can't be the same thing as I was assured that "nobody else has ever had this problem" :lol:

You wouldn't be playing with that particular nest of bugs would you?
Sounds yummy! But no, it's definitely not an ISB-containing sheet; I haven't used (operationally) an ISB for years.

I've also had this on occasion in a non-TM1 session, so I don't think it's TM1 related. It's a relative rarity; probably wouldn't happen more than once every few months, if that. It looks exactly like an empty task pane, just on the wrong side. (And covering the workbook instead of pushing it to the side. More annoying than critical.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: The Excel "Grey Block On The Left Side" issue

Post by lotsaram »

Have you tried dragging a docked menu bar to be a floating taskbar, then re-docking it? Often (for whatever reason) this fixes Excel screen rendering glitches.
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: The Excel "Grey Block On The Left Side" issue

Post by Alan Kirk »

lotsaram wrote:Have you tried dragging a docked menu bar to be a floating taskbar, then re-docking it? Often (for whatever reason) this fixes Excel screen rendering glitches.
Didn't try that, but I shall next time. (I tried toggling various toolbars off and on, but that didn't do anything.) Thanks.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
User avatar
Oratia623
Posts: 40
Joined: Mon Apr 27, 2009 5:36 am
OLAP Product: TM1/PA/CA
Version: V7.x to 2.0.9+
Excel Version: All
Location: Sydney, Australia

Re: The Excel "Grey Block On The Left Side" issue

Post by Oratia623 »

I too have had this GBoD on the left and have noted that it is in the same position as the document recovery pane that is presented when you restart Excel after a crash.
I have gotten into the habit of never using the post crash session of Excel, other than saving the recovered file/s before manually closing down and restarting.
It may be a coincidence, but since adopting this, I have not been pulling my hair out as much as the problem has gone away.
BTW I found that moving a docked menu bar only temporarily fixed the issue.
Paul Williamson
____________________________________________________________________________________
I came. I saw. I did not concur.
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: The Excel "Grey Block On The Left Side" issue

Post by Alan Kirk »

Odd coincidence; I hadn't had this happen for weeks but after yesterday's post, did this morning.

I initially tried Lotsa's suggestion of the floating toolbar; that didn't work as such but did work when I dragged a toolbar down and docked it on the left. An artefact of the GBotLS reappeared when I switched to another window, but shifting the toolbar down cleared it again.

And as per Oratia's post... this was a session which followed a crash. (Specifically one caused by rescheduling a chore :evil: )
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply