refresh data in power pivot automatically without the use of share point

can anybody tell me how to refresh data in power pivot automatically without the use of share point

That is something i would

That is something i would also love to know, apparently it is a feature that will be available in Excel 2013, i have tried a few codes as well but none work