Excel files with Stockmarket that don't wanna update

It seems that you are experiencing issues with updating stock prices in your Excel file on your new Mac. Here are a few troubleshooting steps you can take:

1. Check Excel Version: Ensure that your Microsoft Office 365 is fully updated. Sometimes, older versions may have bugs or limitations that could affect functionality.
2. RealTimeData (RTD) Function: If you are using the RealTimeData (RTD) function to fetch stock prices, note that in Excel M365 version 2002 or later, the RTD function has been improved for better performance. If you are using an older version, consider updating to benefit from these enhancements.
3. External Links: If your Excel file relies on external links to update stock prices, ensure that these links are still valid and accessible. You may need to update or refresh these links manually.
4. Automatic Updates: Make sure that the settings for automatic updates are configured correctly. You can check this in Excel under the calculation options to ensure that it is set to update automatically.
5. Add-ins and Permissions: If you are using any add-ins for stock data, ensure they are enabled and functioning properly. Also, check if there are any permissions or security settings that might be preventing updates.
6. Recreate the File: If the issue persists, consider recreating the Excel file on your Mac to see if that resolves the problem. Sometimes, files created on different platforms may have compatibility issues.

If you continue to experience difficulties, you may want to consult Microsoft support for more tailored assistance.

References:

• Excel performance: Performance and limit improvements
• "Cannot use object linking and embedding" error in Excel 2016 for Mac

Please note that our forum is a public platform, and we will modify your question to hide your personal information in the description. Kindly ensure that you hide any personal or organizational information the next time you post an error or other details to protect personal data.

Dear Fredrik Klameth
Welcome, and thank you for sharing your issue with us in the Q&A forum.

Based on the information you provided, it appears you are having difficulty updating stock prices and adding new companies to your old Excel file after switching to a Mac and purchasing Microsoft Office 365. This is a common situation that often arises from an incompatibility between the old data connection methods (from many years ago) and the modern features of Excel 365 on the macOS platform.

Below is a troubleshooting guide you can follow. To ensure I provide you with the most suitable solution, I need to clarify a few key pieces of information first:

Please help me clarify these points:

• What type of Microsoft Office license are you using: Microsoft 365 Personal/Family/Business (Subscription)? Office Home & Business 2021 (Perpetual/One-time purchase)?
• What tool did you use to fetch stock prices in your old file: A third-party Add-in/Software? VBA Code/Macro programming? Special functions like RTD (Real-Time Data)?

To determine if your Excel 365 application on Mac is working correctly, independently of your old file, please perform this quick test:

• Open a brand-new Excel File.
• In cell A1, type a stock ticker (e.g., MSFT).
• Select cell A1, go to the Data tab, and click Stocks (in the Data Types group).

If the result is: Success (Cell shows a stock exchange icon): Your Mac application is working well. The problem is with the old connection methods (VBA/RTD) that are incompatible with Mac.

If the result is: Failure: Service connection or license issue.

The best solution is often to move to the current standard, as most old methods (like RTD) are difficult or impossible to run on Mac.

• The best approach is to rebuild your stock tracker using the Stocks Data Type feature, as tested above.
• Secondary Check (Using the Web): Please try uploading your old Excel file to OneDrive and open it with Excel Online in your web browser. Then, try clicking Refresh on the data.
• This test helps rule out local configuration issues on the Mac. If the price still doesn't update online, it confirms that the original file is using an obsolete and unsupported connection method.

Please try these steps and provide feedback on the information requested in scoping question, along with the outcome of the Stocks Data Type test. Feel free to share any issues that arise; I am ready to assist you further.

Update: The customer has confirmed that he has wrong Excel. Here are some suggestions that may help resolve the issue.
To use the Stock Data Types feature in Excel, you’ll need a Microsoft 365 Business plan (such as Business Standard, E3, or E5).

-Upgrade your subscription

• Go to https://www.microsoft.com/microsoft-365/business and choose a business plan.
• Complete the purchase and create a business account (tenant) with a domain like yourcompany.onmicrosoft.com.

-Sign out and sign back in

• In most cases, you don’t need to uninstall or reinstall Office.
• After upgrading, sign out of all Office apps and sign back in using the account with the new Business license.
• Then go to File >> Account >> Update Options >> Update Now in Excel to ensure you have the latest features.

-If features still don’t appear

• Check that your Business license is active under Services & Subscriptions.
• Restart your device and excel.
• If the issue persists, you may need to repair Office or reinstall, but this is rarely required.

Important:

• Complete the payment and set up your business tenant before switching.
• If you want to keep your existing data, make sure to back up your files before moving to the new account.

If you think my reply is helpful to you, please remember to mark it as an answer. Warm thanks.

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.

Hi,

No i can’t either make stocks in excel or update the file i have.

How i know if i have the right 365 office?

It feels like that i have a version that not fit to to what i wanna do, my main work is to build stock lists that will update by it self.

So could you help me see if the version i have is the right one on my account?

//Fredrik

Ok then i have wrong Excel!

I have the 365 Personal today, then i need to change to 365 business then, is it just to change and the excel will work or i need to wait or delete and download again or something?

//Fredrik