Skip to main content

UnaXL v20260904 (Release)

· 2 min read

✨ UnaXL Software Release​

This release lets UnaXL write to password-protected worksheets, adds automatic refresh after save, brings dimension-role filters to Excel, gives grids new dynamic sizing options, and fixes several filter, grid, and sheet-protection issues.

New Features & Enhancements 🚀​

Protected Worksheets​

  • UnaXL Can Now Write to Password-Protected Sheets — Get Data now works on worksheets protected with the standard password Una123. UnaXL unlocks the sheet just long enough to update your data, then re-protects it automatically, so end users still can't edit it by hand.

Automatic Refresh​

  • Auto-Refresh After You Save — A new workbook settings option lets you turn on automatic data refresh after you save your data, so other reports connected to the same data stay up to date without an extra manual step.

Filters​

  • Filters Can Now Use Dimension Roles — Like grids, filters can now be built around a dimension role (such as Time or Entity) instead of one specific dimension name. The same filter set can then be reused across different models and tenants without rebuilding it.

Grids​

  • Grids Can Now Skip Empty Ranges — A new Dynamic Grid option leaves out grid sections that have no data, instead of showing empty data ranges, so your sheet matches what you'd see in the Una Portal.
  • Grids Can Automatically Grow or Shrink — A new Local Resizing option lets grid rows and/or columns automatically adjust the formula row/columns based on the incoming data size.

Fixes & Improvements 🛠​

  • Multi-Word Filter Names No Longer Cause Errors — Fixed an issue where dimension names with more than one word (like "Business Units") caused an error when Excel set up the named range for that filter.
  • New Grids Now Respect "Allow Retrieve" Being Off — Fixed an issue where a brand-new grid with Allow Retrieve turned off still filled in data on its first refresh, overwriting anything already in those cells. Headers populate as expected while your own entries stay untouched.
  • Filter and Trigger Actions Now Respect Sheet Protection — Fixed an issue where filter sets and triggers could still be added, edited, or deleted on a protected worksheet, even though grid changes were correctly blocked. These actions are now disabled too, consistent with how grids already behave.
  • Confirmed Dimension Role Grids Work as Expected — Verified that grids built using dimension roles behave the same way as Una Matrix grids.