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
- You must be logged in to reply to this post.
Sign in with LinkedIn or Google to take part.
Home › Discussions › Questions & Answers › Granular Control Over FSG Data Refresh
Customer · · Questions & Answers · 7 replies
If I only want to refresh cells that show ‘(pending)’ status, which refresh option should I choose?
To refresh only cells requiring recalculation, which are marked as ‘(pending)’, you should click the ‘Pending’ refresh button.
If I need to update all data across my entire workbook, what is the quickest method?
You should use the ‘Workbook’ refresh button to refresh all calculations throughout the entire workbook.
Can I target specific, non-contiguous cells for refresh?
Yes, you can hold Ctrl while selecting multiple ranges and then click the ‘Range’ refresh button to calculate only the selected cells.
What about updating just one specific worksheet?
To calculate the functions on an entire sheet, you simply click the ‘Sheet’ refresh button while that sheet is selected.
Sign in with LinkedIn or Google to take part.