Excel 2019: Make Your Workbook into a Web App
June 03, 2019 - by Bill Jelen
Create a named range such as DisplayMe that surrounds your dashboard. To do so, select File, Info, Browser View Options. Choose Items in the Workbook on the Show tab and select the named range DisplayMe.
Save your workbook to a OneDrive location. Use File, Share and ask for a sharing link, as shown below.
Anyone who has the link can open the file in a browser and interact with the slicers. Try it: mrx.cl/livdashboard
Anyone who has the link can download the workbook and unhide the data sheets.
Title Photo: Valery Rapovets at Unsplash.com