This is a limitation put by Google itself. Google Sheets will only run up to 30 custom functions simultaneously. Any other function will be queued and that may then fail to give any result and instead give an error. For reference, please visit the link below:
https://developers.google.com/apps-script/guides/services/quotas#current_limitations