MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Make Your Workbook into a Web App


June 03, 2019 - by Bill Jelen

Excel Make Your Workbook into a Web App. Photo Credit: Valery Rapovets at Unsplash.com

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.

In the Browser View Options, choose All Named Ranges.

Save your workbook to a OneDrive location. Use File, Share and ask for a sharing link, as shown below.


In the Share panel, choose Get a Sharing Link.

Anyone who has the link can open the file in a browser and interact with the slicers. Try it: mrx.cl/livdashboard

The dashboard rendered in a browser window. You can still click the slicers and the charts and data will update.

Caution

Anyone who has the link can download the workbook and unhide the data sheets.

Ryan Wilson suggested making Excel not look like Excel.

Title Photo: Valery Rapovets at Unsplash.com


Bill Jelen is the author / co-author of
MrExcel 2020 - Seeing Excel Clearly

This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.