There is no hard cap on the number of XAVI formulas you can use in a workbook.
However, refresh performance depends on the amount of data requested and the NetSuite API resources available when the formulas are refreshed.
What Limits Apply?
A single Refresh All operation is subject to NetSuite’s API response limit. NetSuite can return up to 1,000 rows of source data during each Refresh All operation.
This limit does not restrict the number of XAVI formulas that the workbook can contain. It affects the amount of underlying NetSuite data that can be retrieved during a full workbook refresh.
Workbooks containing many formulas may also reach NetSuite concurrency limits, depending on other activity occurring in the connected NetSuite account at the same time.
These are NetSuite API limitations, not hard limits imposed on the number of XAVI formulas.
How Refresh All and Refresh Selected handle limits
Starting with v1.9, Financial Reporting automatically adjusts how many requests it sends to NetSuite at once so large refreshes stay within your account's limits.
Live progress: a status display shows the total number of cells and how many are refreshed, pending, and failed. Excel stays responsive during the refresh.
Automatic retries: failed cells are retried automatically before the refresh finishes.
Retry Failed: If any cells still fail, for example, when other integrations or scripts are using your NetSuite account at the same time, select Retry Failed to re-run only those cells.
Refresh Selected works the same way as Refresh All.
Recommended Approach
Use Refresh Selected whenever you only need to update a specific range, column, or group of formulas.
Refreshing a smaller selection:
Reduces the volume of data requested from NetSuite.
Lowers the chance of reaching NetSuite concurrency limits.
Helps the selected formulas return accurate results in a single refresh.
Example
Your workbook contains financial data from January through September.
If the January through August values have not changed and you only need the latest September data:
Select the cells or column containing the September XAVI formulas.
Click Refresh Selected.
Confirm that the September values have updated.
You do not need to use Refresh All when the earlier periods have not changed.
Best Practices
Use Refresh Selected for recently changed periods or sections.
Avoid refreshing the entire workbook when only a small portion requires updated data.
If some cells show as failed after a refresh, select Retry Failed rather than refreshing the entire workbook.
Divide large refreshes into smaller ranges when necessary.
Consider other integrations or processes using NetSuite API resources when scheduling large refreshes.