Excel macro on CRM report output

(0) Share

Report

Posted on by Barbara Forsman

608

I have exported a CRM report to Excel and written a macro in Excel to do some calculations etc. based on field values. When I run the macro, all the columns from the report output shift to the right beyond the columns I've added in my macro, so the calculations I've included in the macro result in 0.

I have not yet learned SSRS report writing so I was hoping a macro in excel would be a stop-gap for this. Can excel macros be used on CRM report output?

Thanks in advance!

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

RyanCPerry 105 on at

Like (0)

Report

I second this question, but with regard to macro support at all for D365 online (8.2 Specifically). When attempting to upload a macro-enabled workbook, I get a "file type not supported" error. Is there a security setting or workaround for this?

Was this reply helpful? Yes No