Excel Dashboard not refreshing

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.

https://lh3.googleusercontent.com/-nDJ6MnXjzCY/VXaVSY72Z3I/AAAAAAAAAZo/xA2Qj94dQ68/s1600/Screen%2BShot%2B2015-06-04%2Bat%2B11.03.48%2BPM.png
Thanks,
James

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

··· 2015-06-09 7:28 GMT+00:00 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.

https://lh3.googleusercontent.com/-nDJ6MnXjzCY/VXaVSY72Z3I/AAAAAAAAAZo/xA2Qj94dQ68/s1600/Screen%2BShot%2B2015-06-04%2Bat%2B11.03.48%2BPM.png
Thanks,
James


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.
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

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

··· On 9 June 2015 at 22:48, Patrick Keating wrote:

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

2015-06-09 7:28 GMT+00:00 James Tinkamanyire jamestinkamanyire@gmail.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.

https://lh3.googleusercontent.com/-nDJ6MnXjzCY/VXaVSY72Z3I/AAAAAAAAAZo/xA2Qj94dQ68/s1600/Screen%2BShot%2B2015-06-04%2Bat%2B11.03.48%2BPM.png
Thanks,
James


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.
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


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

*James Tinkamanyire *| Data Manager

Measuring Early Treatment Adherence - META ProjectGlobal Health
Collaborative - MUST - Uganda

P.O. Box 1397, Mbarara.

BSc Computer EngineeringMBARARA UNIVERSITY OF SCIENCE & TECHNOLOGYP.O. Box
1410, Mbarara, Uganda.

Mobile Tel: +256 (0)702 864 964
Work Tel: +256 776 864 965
Skype: jimmyjaymes1
Alt email: jtinkamanyire samira@mgh.harvard.edu@mustresearch.org
http://www.mghcgh.org/
Website: www.ghc.org http://www.mghcgh.org/

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

··· 2015-06-10 6:12 GMT+00:00 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

On 9 June 2015 at 22:48, Patrick Keating pkeating@dimagi.com wrote:

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

2015-06-09 7:28 GMT+00:00 James Tinkamanyire <jamestinkamanyire@gmail.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.

https://lh3.googleusercontent.com/-nDJ6MnXjzCY/VXaVSY72Z3I/AAAAAAAAAZo/xA2Qj94dQ68/s1600/Screen%2BShot%2B2015-06-04%2Bat%2B11.03.48%2BPM.png
Thanks,
James


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.
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


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

*James Tinkamanyire *| Data Manager

Measuring Early Treatment Adherence - META ProjectGlobal Health
Collaborative - MUST - Uganda

P.O. Box 1397, Mbarara.

BSc Computer EngineeringMBARARA UNIVERSITY OF SCIENCE & TECHNOLOGYP.O.
Box 1410, Mbarara, Uganda.

Mobile Tel: +256 (0)702 864 964
Work Tel: +256 776 864 965
Skype: jimmyjaymes1
Alt email: jtinkamanyire samira@mgh.harvard.edu@mustresearch.org
http://www.mghcgh.org/
Website: www.ghc.org http://www.mghcgh.org/


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.
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