Create Shareable, Interactive, View Only Dashboards from Excel | Excel Off The Grid
★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy
★ Check out the blog post★
https://exceloffthegrid.com/view-only...
★ About this video ★
Often as Excel users, we can look across at Power BI and see the convenience of having a sharable web-based dashboard. It's nice to have each person viewing a dashboard without affecting other users. We don't have anything similar in Excel... or do we?
Normally, if we share an Excel Workbook saved in OneDrive or SharePoint, every change made by a user updates the file. Therefore, it affects everybody else viewing the report. That's not ideal if multiple users are trying to view the report at the same time.
We could email the report to all users, but that is not keeping a single version of a file. Plus, if it's a live report we could be emailing it every day!
So, how can we create a view-only interactive dashboard from Excel, which is linked to one source?
That's what we are looking at in this video
CONTENTS
0:00 Introduction
0:55 View only interactive dashboard
5:45 Conclusion
Acknowledgments:
While I have been aware of Excel's sharing/embedding techniques for a while. The method shown in this video is from Chris Webb's presentation to the Toronto Excel Meetup Group ( • MS Excel Toronto - BI with Excel - ... ). Please go watch the video, it's got some amazing techniques.
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: / exceloffthegrid
#MsExcel