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.