Granular Control Over FSG Data Refresh

If I only want to refresh cells that show ‘(pending)’ status, which refresh option should I choose?

7 replies

Support Enginatics November 9, 2020
To refresh only cells requiring recalculation, which are marked as ‘(pending)’, you should click the ‘Pending’ refresh button.
Customer November 10, 2020
If I need to update all data across my entire workbook, what is the quickest method?
Support Enginatics November 11, 2020
You should use the ‘Workbook’ refresh button to refresh all calculations throughout the entire workbook.
Customer November 12, 2020
Can I target specific, non-contiguous cells for refresh?
Support Enginatics November 13, 2020
Yes, you can hold Ctrl while selecting multiple ranges and then click the ‘Range’ refresh button to calculate only the selected cells.
Customer November 14, 2020
What about updating just one specific worksheet?
Support Enginatics November 15, 2020
To calculate the functions on an entire sheet, you simply click the ‘Sheet’ refresh button while that sheet is selected.