Once a dataset exists, there are two ways to get it into the sheet: click it in from the panel, or type a formula to reference it. Clicking it in is the usual choice, because it brings your number and currency formatting with it.
Click it in from the panel
Select the cell where you want the table to start.
Open the panel and go to Datasets.
Find your dataset and click the table icon next to it.
Result: your data drops in as a proper Excel table — currencies, decimals, and layout already applied — right where you clicked.
To create a dataset first, see Create and manage datasets.
Or type a formula
You can also pull a dataset in with a formula:
=ASTRATO.TABLE("Sales")
This spills the data — a header row plus the rows beneath and to the right — starting at that cell.
Tip: For bigger datasets, create a separate sheet so the spill has room. See “The table won’t spill” in Troubleshooting if you hit a #SPILL! error.
One difference: a formula returns the values only. Your number and currency formatting is applied when you click a dataset in (or refresh it) from the panel — not from a bare formula.
More on the ASTRATO functions: Excel functions.
Refresh an inserted table
To update an inserted table, use the refresh icon in the dataset list or editor.
How refresh modes control this: see Refresh modes in Create and manage datasets.
Cache entries
When a dataset refreshes, the Add-in saves its results (the cached data) inside the workbook so the numbers still show when you’re offline or when you share the file. Cache entries lets you see and manage everything that’s saved.
Open Cache entries from the three-dots menu to see a list of saved results.
Each entry shows the dataset it belongs to, its size (rows and columns), and when it was last fetched. If a dataset has been used a few different ways — different filters, variables, or parameters — you’ll see one entry per variant.
Here you can:
Search and sort the list to find an entry.
Delete a single entry with the trash icon beside it.
Delete everything with the trash icon in the search bar.
Why clear the cache?
Shrink the workbook — cached results add to the file size; clearing them makes the file smaller.
Force fresh data — remove a saved result so the dataset re-fetches next time instead of reusing what’s stored.
Remove data before sharing — clear saved figures out of a workbook before you send it on.
Warning: Clearing a cache entry can’t be undone with Ctrl+Z. If a dataset’s refresh mode is Refresh manual, it will show #NO_DATA until you refresh it again, because there’s no longer a cached result to fall back on.