Reasons that Table Functions Are Causing Excel to Crash

Corrupt DLL File
Most Excel spreadsheets use VBA (Visual Basic for Applications) codes for advanced functions, and VBA codes may use DLL files. If the DLL file being used by your spreadsheet is corrupt, your Excel file will crash whenever a table function using that file is evoked. You can fix this by replacing the DLL file with a one that works. It might be easier to replace all DLL files rather than trying to find the one that doesn't work.
Circular Reference Error
A circular reference error in Excel happens when a cell with a formula points to itself to calculate its final value. If your table function causes one or more circular reference errors, there is a good chance that your Excel file may crash. The best way to fix this is to look at the formula cell. Excel will show you which cells are in conflict. Check the formula and replace it with a one that works. Your circular reference error will be gone.
Faulty VBA Code
VBA code is often used to enhance the functionality of Microsoft Excel. If your code has syntax or a logical error, your Excel file may crash. It can crash on startup or when a particular function is called that causes the VBA code to execute. You can get rid of this error by fixing the syntax or logical error in your VBA code. In cases of a logical error, it might be easier to write the code from scratch if you are not able to identify the error.
Incompatibility of Add-Ins
There are many Excel Add-Ins. Sometimes you will download a file that works fine on some other computer but crashes on your computer. This could happen because your version of Excel might not support the add-ins the file needs to run or you might not have that particular add-in installed. You can update your Excel to the latest version to fix this error. You might have to pay to upgrade to the latest version.