Excel Dashboard not refreshing

13 views
Skip to first unread message

James Tinkamanyire

unread,
Jun 9, 2015, 3:28:38 AM6/9/15
to commcar...@googlegroups.com
Hi CommCare users,

I need a little help about an excel dashboard. I have colleagues of mine who can not refresh an excel dashboard that I shared with them. I can easily refresh the same spreadsheet and get new data pulled in but they can't. They get an error message "can not open pivot table source file." I have attached a screenshot for more reference.

Thanks,
James

Patrick Keating

unread,
Jun 9, 2015, 3:49:37 PM6/9/15
to commcar...@googlegroups.com
Hi James,

Quick question, can you check the data source for the pivot tables in your excel dashboard?
It's possible that the pivot table is referencing a data source from a document that you have locally, but to which your colleagues don't have access.

I think if you ask your colleagues to change the data source of their pivot tables to reflect the data in their own document, that might help.

Thanks,
Patrick




--
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-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--
Patrick Keating

Field Manager | Gestionnaire sur terrain
West Africa | Afrique de l'Ouest
Dimagi, Inc
Mob Sénégal: +221775716949
Mob Burkina Faso: +22674434915
Skype: patby19

James Tinkamanyire

unread,
Jun 10, 2015, 2:13:38 AM6/10/15
to commcar...@googlegroups.com
Thanks Patrick! By changing the data source do you mean they would have to go to Options->Change Data Source? I know that this is the procedure in Excel 2007 but I am not sure how to do this on a MAC. Any thoughts?

Thanks,
James

--
You received this message because you are subscribed to a topic in the Google Groups "commcare-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/commcare-users/l76eJ_AaLjA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to commcare-user...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.



--
-----------
James Tinkamanyire | Data Manager
Measuring Early Treatment Adherence - META Project
Global Health Collaborative - MUST - Uganda

P.O. Box 1397, Mbarara.

BSc Computer Engineering
MBARARA UNIVERSITY OF SCIENCE & TECHNOLOGY
P.O. Box 1410, Mbarara, Uganda.

Mobile Tel: +256 (0)702 864 964
Skype: jimmyjaymes1


Patrick Keating

unread,
Jun 10, 2015, 4:45:50 AM6/10/15
to commcar...@googlegroups.com
Hi James,

I meant exactly that, they just normally just click on the pivot table-->Analyse--->change data source. Hope it helps.
Found this link for how to do it on a mac http://www.techonthenet.com/excel/pivottbls/data_source2011.php
Thanks,
Patrick
Reply all
Reply to author
Forward
0 new messages