Dashboard closes upon certain slicer selections

[btadams]

Hope you are all having a great day!

I have a dashboard with 6 slicers. Some combinations of slicer selections have very little data and when I make those selections, Excel simply closes down (and it doesn't have any list of recovered files when I re-open Excel.). I don't think my customers would appreciate this happening to them The dashboard is a single chart with the 6 slicers and then there is a sheet with the raw data and another sheet with a single pivot table. I asked a co-worker to play with it and the same behavior occurred. Has anyone come across this and found a fix?

Thanks,

Brian
Excel 2013

 

[btadams]

I've figured out how to keep Excel from crashing. I created dynamic named ranges for the X and Y data in the chart rather than using fixed ranges.