Excel RTD function works on old Win10 PC and does not on new Win11 Laptop

gar 20 Reputation points
2026-09-12T16:53:05.9633333+00:00

I've just bought new HP Win11 Laptop and want to add it to my old Win10 PC I can open files transferre to it by USB and open excel files. But the RTD function that works well on old PC gives me on new laptop the #N/A instead of value. it supped to get the answer trom Think or Swim that is working on either machine

Microsoft 365 and Office | Excel | For home | Windows
0 comments No comments

Answer accepted by question author
Hendrix-V 18,925 Reputation points Microsoft External Staff Moderator
2026-09-13T02:36:58.1766667+00:00

Hi gar,Since the workbook opens correctly on the new Windows 11 laptop and the issue only affects the RTD() formulas, the problem is likely related to the connection between Excel and the Thinkorswim RTD server rather than the workbook itself. The thread indicates that the same formulas work on the original Windows 10 PC but return #N/A on the new system.

You may want to try the following:

  1. Verify that Thinkorswim is running before opening the workbook.
  2. Check Excel > File > Options > Add-ins and confirm any Thinkorswim-related COM add-ins are enabled.
  3. Ensure Excel and Thinkorswim use compatible architectures (both 32-bit or both 64-bit where applicable).
  4. Test the same RTD formula in a new blank workbook to determine whether the issue is workbook-specific.
  5. Repair Microsoft 365 Apps or reinstall the Thinkorswim Excel integration on the Windows 11 device.

If the formulas continue to return #N/A, comparing the Excel and Thinkorswim versions installed on both computers may help identify any configuration differences.

I hope this points you in the right direction. Let me know if you need further assistance, feel free to ask me by clicking "Add Comment" or "Add Answer" if you cannot add comment so your response will be visible. Thanks for your effort.


Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Was this answer helpful?

1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
  1. gar 20 Reputation points
    2026-09-13T18:31:00.1566667+00:00

    Unfortunately there is nothing related to Thinorswim in my win11 laptop while thinkorswim app is working. How to get it? Thank you. :-)

    Was this answer helpful?

    0 comments No comments

  2. gar 20 Reputation points
    2026-09-13T18:30:37.5166667+00:00

    Unfortunately there is nothing related to Thinorswim in my win11 laptop while thinkorswim app is working. How to get it? Thank you. :-)

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.