The Datarails Flex Add-In enhances your Excel experience by allowing seamless integration with live data from your Datarails environment. Among its many features, Embedded Ranges provide a dynamic way to display and manage data within your spreadsheets. This article will guide you through the functionality and usage of embedded ranges in the Flex Add-In.

Embedded Ranges allow users to insert live data from Datarails directly into Excel cells while maintaining full interactivity. Unlike standard widget imports that display static visualizations, embedded ranges provide a structured data format that updates in real-time based on applied filters and reference dates.

Create an Embedded Range

1. Open your Excel workbook and navigate to the Datarails tab in the ribbon.

2. Click on Import Widget to open the widget library.

3. Select the desired Dashboard from which you want to import data.

4. Choose the Embedded Range option from the available widget types.

5. Once selected, define the range of data you want to embed.

6. You can choose specific dimensions, measures, and time periods to tailor the data to your needs.

7. Click Import to insert the live data into your Excel sheet.

• Updating Data: When the source data changes, the embedded range updates automatically.

• Applying Filters: Modify the reference date or apply additional filters in the Datarails ribbon to adjust the data dynamically.

• Editing Layout: You can resize the embedded range within Excel without affecting its functionality.

Refreshing Embedded Ranges

To ensure your data remains current, you can refresh embedded ranges using the following options:

• Click the Refresh button in the Datarails ribbon.

• Use the dropdown under Refresh to select:

  • Refresh the selected range

  • Refresh all embedded ranges in the workbook

Key Benefits of Embedded Ranges

• Live Data Updates: Embedded ranges stay synced with your Datarails environment, ensuring accuracy.

• Flexible Reporting: Enables data manipulation and formatting within Excel.

• Seamless Integration: Works in conjunction with other Excel features, including formulas and pivot tables.

Limitations

• Embedded ranges do not support direct modifications in Excel; changes must be made in Datarails.

• Large datasets may require additional time to load, depending on data complexity.

Conclusion

The Embedded Ranges feature in the Datarails Flex Add-In empowers users with real-time, structured data within Excel, enhancing analysis and reporting capabilities. By leveraging this tool, you can ensure your spreadsheets always reflect the most up-to-date insights from your Datarails environment.

Updated February 12, 2025 13:53