Tyler_Analyst
Board Regular
- Joined
- Dec 16, 2015
- Messages
- 57
I have a report I have to run that requires me to open up the power pivot window, select refresh all, enter in a username and password for the server then click ok. The PowerPivot refreshes the data eventually. Next I have to do a front-end refresh all under the data tab.
My issue is I want to write a macro that does all this for me so I can run the report when I am away from the desk. Does anyone have a suggestion on how to refresh all the power pivot window and store the password/enter the password in automatically.
Thanks!
My issue is I want to write a macro that does all this for me so I can run the report when I am away from the desk. Does anyone have a suggestion on how to refresh all the power pivot window and store the password/enter the password in automatically.
Thanks!