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

%3CLINGO-SUB%20id%3D%22lingo-sub-1387903%22%20slang%3D%22en-US%22%3EHow%20to%20export%20a%20XLS%20template%20with%20data%20to%20a%20format%20where%20any%20user%20can%20use%20Active%20X%20controls%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1387903%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20report%20in%20Excel%20with%20some%20Active%20X%20display%20bars%20to%20provide%20flexibility%20in%20calculating%20different%20scenarios.%20I%20would%20like%20to%20share%20this%20type%20of%20reports%20in%20a%20non-modifiable%20format%2C%20for%20example%20(HTML%2C%20pdf%2C%20other)%20but%20where%20it%20would%20still%20possible%20to%20action%20the%20display%20bars%2C%20and%20other%20funcionalities%20like%20drop%20down%20menus%2C%20etc..%20I%20have%20tried%20to%20save%20as%20HTML%20other%20formats%20but%20I%20was%20unable%20to%20get%20the%20appropiate%20outcome.%3C%2FP%3E%3CP%3EI%20do%20not%20want%20to%20build%20a%20website%2C%20just%20wanted%20to%26nbsp%3Bkeep%20it%20simple.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1387903%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1394077%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20export%20a%20XLS%20template%20with%20data%20to%20a%20format%20where%20any%20user%20can%20use%20Active%20X%20controls%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1394077%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F667093%22%20target%3D%22_blank%22%3E%40Alvaces%3C%2FA%3E%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20recommend%20you%20to%20use%20PowerBI%2C%20this%20will%20add%20value%20to%20what%20you%20doing%20right%20now.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn-fact%20you%20will%20have%20more%20control%20on%20your%20report%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted

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