# Excel dashboard crashing

**URL:** <https://forum.dimagi.com/t/excel-dashboard-crashing/2349>\
**Category:** Users\
**Created:** [August 7, 2015, 6:09pm UTC](https://forum.dimagi.com/t/excel-dashboard-crashing/2349 "2015-08-07T18:09:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![John\_Skelton](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/j/d2c977/32.png) [@John\_Skelton](https://forum.dimagi.com/u/John_Skelton)\
**Post date:** [August 7, 2015, 6:09pm UTC](https://forum.dimagi.com/t/excel-dashboard-crashing/2349/1 "2015-08-07T18:09:24Z")

</div>

Hi all,

I have developed an Excel dashboard that involves pulling daily data from  
about three forms. Usually this works well (although it can take some time  
on certain computers to pull in the new data when opening the file).

However, a couple of times the file has been damaged when trying to open. I  
cannot remember the precise message that appears on the screen but it seems  
to related to the slicers that I am using in the dashboard. When this  
happens, all of the pivot charts disappear from the dashboard file,  
although the pivot tables remain. When this happens, the damage is  
permanent, e.g. when I close the file and reopen it, the pivot charts are  
still not there and have to be recreated.

I would be interested if anyone else has experienced this and/or has any  
suggestions about what the cause could be.

Thanks!  
John

---

<div class="post-metadata">

**Author:** ![Nate](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/n/e95f7d/32.png) [@Nate](https://forum.dimagi.com/u/Nate)\
**Post date:** [August 12, 2015, 3:01pm UTC](https://forum.dimagi.com/t/excel-dashboard-crashing/2349/2 "2015-08-12T15:01:35Z")

</div>

Hi John,

I haven't heard of this particular behavior happening and a quick google  
search on the topic hasn't turned up anything fruitful. Let us know if you  
are able to find this error message in the future and you think that it  
might be related to something in CommCare. Otherwise, Excel support and  
documentation will probably be the best place to look.

Thanks,

Nate Haduch

Technical Support Analyst  
Dimagi, Inc | 585 Massachusetts Ave | Suite 3 | Cambridge, MA 02139

> **···**
>
> On Fri, Aug 7, 2015 at 2:09 PM, John Skelton wrote:
> 
> > Hi all,
> > 
> > I have developed an Excel dashboard that involves pulling daily data from  
> > about three forms. Usually this works well (although it can take some time  
> > on certain computers to pull in the new data when opening the file).
> > 
> > However, a couple of times the file has been damaged when trying to open.  
> > I cannot remember the precise message that appears on the screen but it  
> > seems to related to the slicers that I am using in the dashboard. When this  
> > happens, all of the pivot charts disappear from the dashboard file,  
> > although the pivot tables remain. When this happens, the damage is  
> > permanent, e.g. when I close the file and reopen it, the pivot charts are  
> > still not there and have to be recreated.
> > 
> > I would be interested if anyone else has experienced this and/or has any  
> > suggestions about what the cause could be.
> > 
> > Thanks!  
> > John
> > 
> > --  
> > You received this message because you are subscribed to the Google Groups  
> > "commcare-users" group.  
> > To unsubscribe from this group and stop receiving emails from it, send an  
> > email to [commcare-users+unsubscribe@googlegroups.com](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
