Datastream AFO problems
Thank you to the students who reported problems with the Datastream AFO Excel add-in. Update Aug 17 2012 – Thanks to Andrew of MBS IT we have a workaround – for details see comment below.
Datastream AFO VB error
Investigation this morning has identified the problem. Microsoft recently issued a critical update which has affected external Visual Basic applications including the Datastream AFO Excel add-in. Thomson Reuters are aware of this but they do not yet have a solution. For details see their Microsoft Update note.
MBS IT advise that as the Microsoft update is critical it is not possible to uninstall it. (There have been increased problems with virus and malware software on campus recently.)
Friday Aug 17, MBS IT have come up with a workaround until Thomson Reuters or Microsoft issue a fix (details in comment below). This should be applied to all our PCs with Datastream on reboot. If you get an error at the first attempt to use the DS AFO Excel add-in then close Excel and try again.
If DS AFO Excel add-in problems persist the alternatives that we can suggest are:
- Use the Datastream Application Interface and export resulting data to Excel.
- Use an alternative database – see earlier Researching Financial Markets post
We realise that these are not ideal if you are in the midst of collecting your dissertation data from Datastream. Please get in touch if you need further help or advice.
In addition, please continue to let us know if you are still having problems with Datastream.
Leave a Reply
Manchester Business Answers 24/7
Online FAQ database from the MBS library service. See the
FAQ - online help page for more details.MBS Library - Flickr
|
Not too sure if this is the same issue we experienced some months ago with datastream. After KB2598041 we experienced a VB Script error when launching the datastream addin from Excel. Our fix was to delete all .exd files.
Unfortunately this is very similar VB script error, but deleting all the .exd files doesn’t solve the problem this time. The Manchester Business School IT service have come up with a suggestion that I’m just going to go and test.
The workaround from MBS IT involves “clearing the user caches and re-registering the MSCOMCTL.OCX component”. I’ve tested this on four PCs with Datastream now. Works fine – once did get error on first attempt but closing and re-starting Excel cleared the problem.
We’ve not yet experienced this issue but thank you for the fix if we do.
Had the same issue at cardiff, we solved it in much the same manner, deleting ComctlLib.exd
MSComctlLib.exd and it was fine after that. Our IT couldn’t figure it out so i googled it
Feedback from our IT and the Thomson Reuters helpdesk was that in our case we also had to re-register the changed component.
regsvr32 %SystemRoot%\system32\MSCOMCTL.OCX
regsvr32 %SystemRoot%\system32\MSCONCT2.OCX
thanks for that Mark, the issue reoccurred here at Cardiff and i passed on your advice and it is sorted now.