Скачать или смотреть Forcing a Static Formula to Execute in Excel

In this video, I found a simple solution to executing a stalled, static, text created Excel formula: Find and replace an = with an =. It is that simple!

This is the opposite of FORMULATEXT. Other solutions did not work such as pressing F9, changing the cell format to TEXT and back to GENERAL, using INDIRECT, using the EXECUTE ribbon command, and closing and reopening the workbook. I sometimes use Excel to create repetitive, non-fillable formulas through string and function concatenation. Once the formula text is created, I copy and paste-as-a-value into a new worksheet. I execute all the formulas by finding and replacing an = with an =. So simple, yet unintuitive!

I hope this helps others looking to streamline their Excel projects.