macros will refresh data but there must be any data
Open Cmd as administrator and run below commands
cd /d “%WINDIR%\Microsoft.NET\Framework\v4.0*”
regasm C:\Zerodha\Pi\ExcelDataStream.dll\
it will fix the issue
copy and paste the above mentioned dos command on my cmd, please see the screen shot, is it correct !!
(checking the timing)
above for him,
the above command is to register the exceldatastream which got unsuccessful as per screenshot.
you can try reinstalling ms excel once and check?
ok, revert you, ur mail id !!? (got msg from support about system time, answer is waste)
THANKS @AlgoGeek FOR YOUR INPUTS
same error for me
i also try https://support.zerodha.com/kb/faq.php?id=52
NOT WORKING !!
For your problem, select enable all, trust setting and macro setting, restart, it’ll cure. same happened to me also.
they gave:
Handy Tip: If it does not work, right click on ZT and on Excel and run both these programs as ‘Administrator.’ If it still doesn’t work, don’t hesitate to pick up the phone and call us.
?!!!
finally excel gets data !!
i copy ExcelDataStream.dll file from pi folder and paste in Microsoft office folder where excel being installed & Boom !!!
thanks @AlgoGeek and @poorna_chandar