Hi Gurus,
I have a challenging requirement in my work and want your expert advice on this.
I have a report that I need to run every one hour to check on the team performance on an hourly basis.
Basically, i have a excel file that is connected to the CRM database using a ODBC connection that is set to refresh the data dump every 1 Hr( Sheet name= Data Dump). I have a pivot table in another sheet ( sheet name =pivot) that gives me the view that i need to monitor.
the requirement is to
-Refresh the dump every 1 Hr ( managed to do this by using the refresh every 60 mins feature in the data connection settings)
- refresh the pivot after dump refresh( not accomplished )
- send an email of the pivot to abc@xyz.com every one hour after the pivot is refreshed.( not accomplished)
please share your expert advice on is this requirement can be managed through a macro.
Regards,
Ak
I have a challenging requirement in my work and want your expert advice on this.
I have a report that I need to run every one hour to check on the team performance on an hourly basis.
Basically, i have a excel file that is connected to the CRM database using a ODBC connection that is set to refresh the data dump every 1 Hr( Sheet name= Data Dump). I have a pivot table in another sheet ( sheet name =pivot) that gives me the view that i need to monitor.
the requirement is to
-Refresh the dump every 1 Hr ( managed to do this by using the refresh every 60 mins feature in the data connection settings)
- refresh the pivot after dump refresh( not accomplished )
- send an email of the pivot to abc@xyz.com every one hour after the pivot is refreshed.( not accomplished)
please share your expert advice on is this requirement can be managed through a macro.
Regards,
Ak