Forum Replies Created
-
AuthorPosts
-
September 15, 2016 at 3:31 pm in reply to: Setting up SharePoint for the PowerPivot Data Models #6129
Hi Tom,
Thanks for your quick reply. I posted the question under power update.
Cheers,
Kevin
September 14, 2016 at 9:52 pm in reply to: Setting up SharePoint for the PowerPivot Data Models #6099Hey Powerpivotpro,
I have a slightly different challenge that more or less falls into this category.
We are currently trying to use the automated scheduled refresh from Sharepoint with power pivot for Sharepoint 2013. Everything works. However, the refresh does not work if we add VBA buttons in the workbook. Indeed, we have a VBA code that is very useful for sharing: a button that transforms a selection or the whole workbook automatically into a pdf, opens outlook and attaches the pdf to the email. Then, the analyst/manager just needs to enter the email address(es) of his colleagues and they get their view of the dashboard on a pdf (good alternative to SSAS tabular and RLS or creating many thin reports, although not interactive).
So, is there a way to auto refresh a workbook that has VBA codes inside? Is it normal that it doesnt work in sharepoint 2013? We do know it is normal that the buttons do not appear in the browser based dashboard though…
Would Power Update be the only way? Would it even be a possible solution?
Thanks a lot for your help,
Cheers
Kevin
-
AuthorPosts