How to export a XLS template with data to a format where any user can use Active X controls

Copper Contributor

I have created a report in Excel with some Active X display bars to provide flexibility in calculating different scenarios. I would like to share this type of reports in a non-modifiable format, for example (HTML, pdf, other) but where it would still possible to action the display bars, and other funcionalities like drop down menus, etc.. I have tried to save as HTML other formats but I was unable to get the appropiate outcome.

I do not want to build a website, just wanted to keep it simple.

 

Thanks,

 

1 Reply

Hi @Alvaces;

 

I would recommend you to use PowerBI, this will add value to what you doing right now.

 

In-fact you will have more control on your report

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more