Skip to Content
1
Former Member
Apr 09, 2009 at 08:11 PM

Auto-Refresh Multiple Workbooks

236 Views

Hey all!

We have a Sales Reporting team that has been using BPC to create reports for Sales Managers. For the most part, everything works great. However, during the first week of the month, our Sales Reporting team needs to open up each individual Sales Manager's report, click "Refresh Workbook", save the report and send it to the sales managers. We have over 400 Sales Managers, so as you might imagine, this is very time consuming.

I've been asked if there is anyway that we can automate this process. I've been butting my head against a wall for a couple of weeks now, but every idea I come up with seems lead to a dead end. Has anyone else tried to do anything like this? Any ideas would be greatly appreciated.

Thanks!

Sean