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.
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.
Divide large refreshes into smaller ranges when necessary.
Consider other integrations or processes using NetSuite API resources when scheduling large refreshes.