How to force calculate an Excel sheet.

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.

Thank you for your help.