I have a C# code that automatically inserts a Bloomberg formula into an Excel-Worksheet cell and applies this formula to the entire column. When I run this code, the Excel workbook opens, and I can see that the cell is calculating (“#N/A Requesting Data…”) aaaaand calculating aaaaaaaaaand calculating. This calculation seems to never comes to an end BUT the value is only returned if I manually click into the cell in Excel, press Enter, and then manually apply the formula to the whole column.

I am not using any Bloomberg package; instead, I am interacting with Excel using Microsoft.Office.Interop.Excel. Does anyone know why this might be happening and how to fix it? Real-time updates are also turned on.

Never ending return: ‘#N/A Requesting Data…”
Expected return: e.g: “AAPL US Equity”