Search code examples
exceldiagrampowerpivotvisual-glitch

Powerpivot diagram view keeps showing blank screen?


I wasn't exactly sure, whether to post this on superuser, given this is likely a visual bug, but who knows, maybe I'm just doing something incorrectly given I'm new to

  • I've recently imported rather large sets of data into my Excel.
  • The import seemed to have went down fine, as data shows correctly inside my PowerPivot

Issue is, when I switch to the Diagram view, for some reason my keeps on showing blank screen, rather than the two tables in Diagram view.

enter image description here

Any idea what could be the cause behind the issue / how to fix it?

(Yes, I did try turning Excel off and on)


Solution

  • I don't have an exact answer and I don't understand how/why it works, but at least it fixed the issue for me:

    • Open the same file on a different computer (eg. I used my laptop)
    • The diagram view should work now, save a separate copy of the file and upload it to your computer (where it doesn't work)
    • The diagram view should work now.

    Not really sure what caused this bug, or even why it fixed it, but it seemed to work :)