Excel Dashboard not refreshing

[James Tinkamanyire]

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]

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

http://www.dimagi.com

[James Tinkamanyire]

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

Work Tel: +256 776 864 965

Skype: jimmyjaymes1

Alt email: jtinkamanyire@mustresearch.org
Website: www.ghc.org

[Patrick Keating]

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