1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Dashboard to all users in my organisation

Discussion in 'Excel Dashboards' started by AthmanArumugam, Jan 8, 2019.

  1. AthmanArumugam

    AthmanArumugam Member

    Messages:
    107
    Hi All,

    I have created a dashboard in excel. This excel dashboard has been accepted by the management. However I wanted to share this dashboard in a common portal.
    Also the dashboard excel has sheets where the data has to be populated by various users.

    We have sharepoint portal. But sharepoint does not work properly for excel with macros.
    Could you please suggest, how can I share my excel dashboard in a distributed environment to multiple stakeholders.
  2. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,171
    Excel isn't really meant for such hosted reports, using macro. There is no reliable method to have macro work on hosted file.

    I'd suggest alternate approach to collecting data, since you have SharePoint portal.

    Create SharePoint list(s), where you collect info (i.e. where data is populated by various users). Then collect data into Excel, either through query from backend (sql), Web query, or SharePoint API. Create dashboard, and distribute, along with credentials needed to connect to data source.

    Other more complex/costly approaches are...
    - Set up reporting service via SharePoint environment. Create report widget within SharePoint.
    - Use PowerBI Pro subscription and connect to SharePoint and publish report.
    - Use IIS server, along with python/R/javascript to collect and publish data from SharePoint. You can use Open Source reporting tool such as AMCharts.
  3. AthmanArumugam

    AthmanArumugam Member

    Messages:
    107
    Thanks Chihiro for your response. I will try based on your suggestions and get back.

Share This Page