Run SSRS report using PowerPivot

[LearningMacro]

Hello All,

I'm new to PowerPivot. I've a SSRS report server which is used by users to run the SQL reports. However, I need to run one of the report on excel so that when user opens the spreadsheet it has all the updated (refreshed data) on it. Can this be done using PowerPivot? Please help.

Thanks

 

[LearningMacro]

Can somebody please help?

 

[GDRIII]

With a SharePoint server you can have PowerPivot workbooks on an auto refresh schedule but, without that you would have to open the PowerPivot window in the Excel workbook, refresh the data coming into the PP window, and then your data would be updated in Excel.