Publishing a view-only online version via OneDrive/SharePoint
When we invite people to collaborate on shared workbooks in Excel, the changes they make in the workbook can impact the original workbook depending on the permissions we set for them. Creating an interactive view-only dashboard in Excel can enhance collaboration and ensure that the people we share our dashboard with can access and view the same dashboard without impacting each other’s changes.
To do this, we can generate a custom URL linked to our dashboard and share this link with others. Sharing it this way means people can see your workbook anytime, anywhere.
Skill three – using OneDrive/SharePoint as a means to share your final work
There are a few things we need to consider first. We will go through them step by step:
- Saving on OneDrive/SharePoint: The process begins by ensuring that our dashboard is saved on OneDrive or SharePoint. We then need to adjust the settings and configurations...
