A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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:
- Verify that Thinkorswim is running before opening the workbook.
- Check Excel > File > Options > Add-ins and confirm any Thinkorswim-related COM add-ins are enabled.
- Ensure Excel and Thinkorswim use compatible architectures (both 32-bit or both 64-bit where applicable).
- Test the same RTD formula in a new blank workbook to determine whether the issue is workbook-specific.
- 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.