I've created a Custom Report in MS CRM 4.0 using the Report Wizard. I had to export this report in Excel and make a pivot table. So far so good. It was easy.
My goal is to create a pivot table that would update itself everytime data is changed in CRM. The CRM to Excel update functionality won't work. What would the best option? Recored a macro? VB code? Any other options?
Please note that pivot table data is not coming direct from CRM. Its first being printed in a report and then exported to excel.