Forum Widgets
Latest Discussions
Error message to say can't install add-ins (where ones I have stop appearing on toolbar)
Hi, I have an accountancy add-in for Excel which normally appears on my toolbar when I load Excel up. For some reason it wasn't there all of a sudden so tried to load it again as an add-in but just get an error message at the bottom of the screen to say that it can't be loaded and to try again later. Tried chatting with Microsoft Support who were no help at all and tried to blame it on the third party software not Excel until I tried loading other add-ins (including Microsoft ones) and get exactly the same message. Tried logging in and out of my account and shutting down and re-starting but to no avail. Any ideas/solutions would be most welcome! Thanks, David
Getting error when adding Add-ins in Excel
Hi all, I have trying to install add-ins to microsoft excel using a M365 Personal Account, and i keep getting an error "Add-in Error: We couldn't connect to the '{0}' catalog server for this add-in" screenshot attached below. I have tried on both Excel Web and and on the desktop Excel app and still the same issue, I have already had a session with microsoft support and they were not able to resolve this for me and directed me to this forum, Any help will be appreciated thanks in advance.
Stock symbol SKHY is missing in Excel's Stock data type
I have been frustrated trying to report a stock ticker symbol that is missing from Excel's Stock data type. SKHY is the ticker symbol for SK HYNIX INC ADR on NASDAQ. Excel responds with the following error when attempting to convert this symbol to a Stock data type: Data Type: Stocks No results found for "SKHY". How do I report this issue so that it can be fixed?
How to move a cell value using an RTD formula (pulling in live updating data) when it changes?
Hi, I am using Interactive Brokers TWS trading platform and they supply a demo excel file that has RTD formulas to pull in a list of available live data trading prices such as Bid, Ask, Last, etc. The RTD connection does not allow you to pull in historical data for the trading prices mentioned above. What I am want to do is the following, if possible: The Last price traded for the MES Futures contract is pulled into cell F3 by using the following formula: I am currently connected to the TWS trading platform and the value in cell F3 is 4761.25 As soon as the markets reopen this value will change continuously. I want to be able to capture the price of 4671.25 that is pulled into cell F3 and move it down by one cell as it changes - for whatever number of cells I decide to capture. For example, if I decide to capture the Last 20 prices, then I want to populate the range F3 to F22. Once I can move the changing values into the cells below, I can then use conditional formatting to change the cell colors based on the criteria I use, which is my objective of the exercise. Thank You.
