Comment on User Settings - Pi

JZ4**9 commented on 08 Jan 2021, 03:14 PM

All the entries in the excel file are #N/A after using link to excel option in Pi. it is opening the excel file with the formulas like =RTD(“pi.rtdserver”, ,”NFO_BANKNIFTY2111432000CE”, “PrevClose”), the value is displayed as #N/A.
I have tried solutions provided over the blogs like the following:
1) copy ExcelDataStream.dll file from pi folder and paste in Microsoft office folder
1. open the run the cmd (command prompt) from the start menu as admin
2. run the below commands one by one
cd “%WINDIR%\Microsoft.NET\Framework\v4.0*”

regasm C:\Zerodha\Pi\ExcelDataStream.dll

None of these worked.
I’m using Microsoft office home and student 2019 on Windows 10

View the full comment thread »