If you are reading this in early January of 2017, wish you a very happy new year! This being the first post in 2017, let’s try something new !
In this post I am going to show you how to publish your report or dashboard (that you have created in Excel) online.
By publishing it online I mean that once you have created the spreadsheet in your computer you can then create a shareable link and multiple users can access that report. And sure enough the report will be dynamic with all the slicers, buttons and fancy controls working in sync.
The only difference(s)
I am going to pick up a recent Dashboard which I made for Chandoo’s Dashboard Contest. My Dashboard had 2 important screens and I only want the users to be able to access only these screens and not the workings of the Dashboard
Read this –> If you need help with Cell and Range naming
If you make any changes in the excel file (which will now also be saved on your local computer and on Onedrive) the users can instantly refresh the link and view the changes!
One of the biggest pro is that it can massively reduce duplicate excel files floating around. Take a look!
One of biggest con is security of data if anyone has the link to your online dashboard they get to see your numbers! So cautious about that
It still is largely helpful in presenting non confidential information to multiple users!
Have you used this feature or a similar feature before? I would love to hear your views on how it went? What were some of the challenges or benefits that you faced
PS: You can do this PowerPoint as well [Broadcast your PowerPoint Presentation]