New entries on my watch list do get current quotes when first entered and
when doing updates most all entries will update however some don't. I have
well 300 entries on the on differnt excel books. When updating about 30 of
the more recent but not the most recent entries return the #VALUE. When
re-enter the symbol it gives the current price but on updates some of these
will update while others get the error. Is there a limit as to how may
quotes I can get? Has anyone solved this problem?

Of course, you are assuming that we read minds here. Care to give us some
detail of which you speak?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mark Taylor" <Mark wrote in message
...
New entries on my watch list do get current quotes when first entered and
when doing updates most all entries will update however some don't. I
have
well 300 entries on the on differnt excel books. When updating about 30
of
the more recent but not the most recent entries return the #VALUE. When
re-enter the symbol it gives the current price but on updates some of
these
will update while others get the error. Is there a limit as to how may
quotes I can get? Has anyone solved this problem?