C#: Bloomberg Excel Api never ending “#N/A Requesting Data” problem
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.