PowerPivot to Analyze Tweets

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,524
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider

maninweb

New member
Joined
Mar 22, 2011
Messages
88
Reaction score
0
Points
0
Location
Germany
Website
excel-translator.de
Excel Version(s)
2010, 2016, 2016 Insider
Hi Ken,

Yes, this is tool is very interesting and cool and I also think, the limitation may
be from Twitter :)

However, users who are not using an English (US) date and system format on
their Windows will encounter a problem when updating the tables due to a
PowerPivot Bug.

So, these users (like me) may firstly change the system date and time format
to English (US) before starting Excel and running Twitter Analyzer data Updates.

Best regards :)
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,524
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Ouch. That's not good!

I saw the following comment on Twitter this morning regarding this one: "Tried out MS' Analytics for twitter. Cool idea, but takes way too many steps to refresh with new search results. #powerpivot"

While not specifically an issue with this add-in, I couldn't agree more. We need a VBA interface to kick off automatic refresh.
 
Top