I am taking in 5 piece of data from a Form and adding rows to an Excel sheet. I have a pivot table to TEXTJOIN some of this data into a single cell, to be used as text in an email. After taking in the original data, 5 steps later, when I send the email, the TEXTJOIN cell still has no data.
How can I force calculate the workbook so that Excel has time to do these 5 calculations?
The 20 or so seconds that the intervening steps need is not enough. (I have read that other people's addition of a time delay of as much as 5 minutes does nothing to help the results.)
Of course, with the sheet live, adding a piece of data to the source cells (almost) instantly adds them to the TEXTJOIN cell.