Overview

After creating a Velixo report, it can sometimes be helpful to be able to view the report directly within your ERP Dashboards

How to do it

Spreadsheets that are saved to SharePoint/OneDrive can be embedded. The main limitation is that they are read-only and cannot be refreshed from the dashboard (this is a limitation within Excel, not Acumatica or Velixo).

You can add them to a dashboard as an external embedded page.

This is accomplished using the Excel Online "Embed" functionality:

Requires:

  • Creating a new dashboard

  • Adding a widget to embed and external Excel Online spreadsheet

The URL you will need can be retrieved by following the instruction here: https://support.microsoft.com/en-us/office/embed-your-excel-workbook-on-your-web-page-or-blog-from-sharepoint-or-onedrive-for-business-7af74ce6-e8a0-48ac-ba3b-a1dd627b7773

If you wish to refresh the report, you can click on the Excel link to view it in Excel Online (with Velixo NX) or the Desktop Edition of Excel with the Classic version of Velixo.

Did this answer your question?