Same problem. Excel 2010, Windows 7 64-bit.
I too get partial updates ... some stocks update, others get #VALUE. When I try again later, still a partial update, but not always the same stocks getting the #VALUE response.
I have not installed IE10, so that does not appear to be the trigger (for me). I did just recently install the June Windows Updates ... I wonder if one of those updates was the trigger?
Anyone getting this problem and has NOT YET installed the June Windows Updates?
Hard to understand how a company with resources like Microsoft's, and quarterly revenues over $20 billion, cannot/will not fix this add-on (or replace it with an equivalent).
I don't think the moderators of this forum have the authority to fix this issue. We need to find a way to bring this to the attention of senior Microsoft management. Any ideas?