Formulas getting freezed when reopening the excel file

[GCRA101]

Description:

When closing and reopening the file, the BHoM formulas don't work and we need to rewrite them to work (example when pulling the Revit materials)
It's possible to create an excel macro that writes the formula automatically as a work-around but it slows down massively the file.

Steps to reproduce:

Save, close and reopen the excel file.

Expected behaviour:

All Formulas to work as expected without any need to rewrite them.

Test file(s):

https://burohappold.sharepoint.com/:f:/r/sites/BHoM/02_Current/12_Scripts/01_Issue/BHoM/Excel_Toolkit/%23402-Formulas-getting-freezed-when-reopening-the-excel-file?csf=1&web=1&e=1vt7fw