Crash on opening file with empty multilevel category chart


Hi everyone - 


I have a file with a chart that has a multilevel x axis (e.g. year and month) and a couple of series in it. I have written some code that filters all series and categories out of the chart when nothing is selected, and the workbook starts in this state. However, once I add a multilevel axis to this chart, filter out (turn off) all series and categories, it causes excel to crash when it is opened. I figured it was something to do with my code, but I tested it on a blank excel file with the same result.


I'm sure everyone will say, you don't need to do that, etc., however, I would *like* to do this, and I don't see why it should be possible with single level categories, but not multi level categories.



0 Replies