TWS API, #N/A error in Excel

Might try deleting the existing or inactive one, and re-add from scratch.

 

Ok thank you I will try that again.

 

Did you ever figure this out? I have the same problem, neither TWS nor Excel support could fix it, and they spent a good amount of time trying.

 

I never got any further on this unfortunately. I’ll have a stab at it again soon.

 

Hello - I had the same problem with TWS API RTD Server for Excel - solved it by the following:
- with Visual Studio (using 2022) - run VS as Adminstrator
- Load the project(s) in the TWS API directory under - source
- build the C# Projects ( I did them as .NET framework 4.8 and 64xbit architecture)
- since you are running the VS as Admin -
- when the projects build (..\TWS API\source\CSharpClient\TwsRtdServer) - during the build VS will update the registry to point RTD to the .dll you just built.

probably a couple of steps I left out - TWS API for Excel is built using C#. You can always build the Sample C# App to test functionality.

Hope that helps -