Hi All
I was wondering whther someone can answer my question.
Is there an easy way for a novice VB coder to be able to automate refreshin Power Pivot Source Data from Power Pivot automatically in excel 2010 ( no Share point). I have a power Pivot connection which gets its data from and excel spreadsheet and I need to refersh this manually before refreshing the Pivot data table.
I looked in web and the only solution I see is from Marco Russo but the code is way to compplicated for me and I keep getting errors.
Any help is appreciate it.
Bookmarks