Why didn’t my dynamic formula update correctly in my Conga Composer Excel output file?

Question or Issue

When I use a Conga dynamic formula in an Excel file and run a merge, the output result displays as #NAME?.

Related Known Errors and Workarounds

The workaround is to use a regular Excel formula when you encounter the issue, or to manually click in the Excel cell and hit Enter for the results to display as intended.