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 powerpivot
- 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 excel keeps on showing blank screen, rather than the two tables in Diagram view.
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 :)
- Excel VBA function to print an array to the workbook
- How do I copy/paste Interior Colors only in Excel?
- Any way to get the real last row not affected by autofilter? Without altering current autofilter status, using UsedRange nor looping cells from bottom
- Using tables and column titles in VLOOKUP
- Auto align data of an Excel table
- Office VSTO Add-ins vs Office Add-ins using Office JS API
- Excel macro to highlight all cells that match value in current cell
- How do I apply conditional formatting in vba?
- Can you display a SQL Server Image datatype column in Excel?
- Excel: macro to export worksheet as CSV file without leaving my current Excel sheet
- Workbook.UpdateFromFile stops runtime
- Merging annotation with differential expression output
- Append to Text File VBA
- Can I check if cells are a Date and change their format?
- Application.OnTime Delays When There Is No User Interaction (Even if Excel Is Active)
- Using Excel VBA (Name statement) to change file extension from .txt to .csv, getting Run-time error '75': Path/File access error
- How to AutoFill using data in every third row?
- Why does Add-Content translates the comma separator from .TotalSeconds into a dot separator?
- How to change the case of a character in a specific expression, using regex?
- Count days within a date range that fall into selected months (via checkboxes)
- Put a user form directly on the excel sheet
- Changing chart types with vba
- How do I find min value of a range
- Return URL From First Search Result
- Change a macro to use late bindings
- How to push data from excel to SQL Server?
- Excel's fullname property with OneDrive
- Using Excel while macros are running
- How to find cells that contain images with openpyxl
- Excel dynamic linest