RTD

adriangray 

Have you looked into Excel's Help function to see what the various causes are for the #NAME error?

It would be kind of hard for anybody else here to diagnose the exact cause from your too brief description. For example, Help tells us that the primary cause for that error is a mistyped function or formula...I would assume that is NOT your cause since you don't experience it.

Here's a list of other possible causes, from Excel "Help"

That last one--referring to a specific add-in--might apply in your case, since you do refer to using "RTD with TD Ameritrade" (but then again, I'm a Fidelity user so don't really know the Ameritrade universe). But if your spreadsheet has an add-in and that other person's Excel doesn't have that add-in, this could be an explanation.

If none of that works, perhaps you could come back with a more complete description, including some words about what's in the cell(s) that get that error message.