I have a workbook where I need to update one sheet in the workbook (I'll call it Data_Feed) on a regular basis. I am just now learning about powerpivot. I have installed the Powerpivot addin for Excel 2010 and it seems to work fine. I have been able to get the same data from a data feed with either a Url to an rdl file or an atomsvc file. I've read numerous web pages but have not found an answer to my question. I want to have powerpivot update the data on the Data_Feed sheet in my workbook when I open the workbook. What I'm having trouble with is how do I link the worksheet Data_Feed to the Powerpivot table and have the Data_Feed worksheet updated. I feel like I'm close but missing some key bit of information.
Thanks, renigar
Thanks, renigar
