Updating Unresolved Functions

You can update the functions that remain unresolved after a sheet refresh.

Google Sheets typically supports refreshing of up to 1500 functions in a spreadsheet. While refreshing functions in a Smart View sheet, some functions may remain unresolved. This may happen if the sheet contains a large number of functions or if the refresh operation crosses Google Sheets' timeout threshold of 30 seconds. Cells with unresolved functions display the #Error code.

Instead of refreshing the whole sheet again, you can use the Update Unresolved Functions option to refresh only the cells with #Error and resolve the functions correctly.

To update unresolved functions:

1. In the Extensions menu, select Smart View for Google Workspace, and then select Functions.
2. Select Update Unresolved Functions.

   The cells with #Error are refreshed to resolve the function and display the values.