Skip to contentBrand Logo
Tech CommunityCommunity Hubs
Products
Topics
BlogsEvents
Skills-Hub
Community
RegisterSign In
  1. Microsoft Community Hub
  2. CommunitiesProducts
  3. Microsoft 365
  4. Excel

Forum Discussion

sdparkers's avatar
sdparkers
Copper Contributor
Jul 11, 2023

Unable to update Stock prices

I've been using this spreadsheet for years and the last couple of days I've been unable to update the prices. It says log into Excel with an account that has access to these subcription services (or something like that) and I am logged in, I have a 365 account, but no update. Tried to log out and then back in... still unable to update. Any ideas? Did they change something?

Formulas and Functions
office 365

1 Reply

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Jul 11, 2023
    You are not alone:

    https://techcommunity.microsoft.com/t5/excel/stock-data-types-wont-refresh-provides-erroneous-error-message/td-p/3870183

    https://techcommunity.microsoft.com/t5/excel/excel-365-not-updating-stock-prices-retreives-only-prior-day/td-p/3771035

    https://techcommunity.microsoft.com/t5/excel/yahoo-finance-data-blocked-for-all-stocks/td-p/3871256

    https://techcommunity.microsoft.com/t5/excel/refreshing-stock-prices-in-excel-has-stopped-working-asking-for/td-p/3870615

    https://techcommunity.microsoft.com/t5/excel/stockhistory-function-is-suddenly-blocked/td-p/3870310

    https://techcommunity.microsoft.com/t5/excel/excel-365-stock-data-not-updating-all-stocks/td-p/2916144

    https://techcommunity.microsoft.com/t5/excel/excel-blocked-error/td-p/3870958

    https://techcommunity.microsoft.com/t5/excel/excel-fails-to-recognize-my-account-when-referring-to-datatype/td-p/3870786

Share this page

What's new
  • Surface Pro
  • Surface Laptop
  • Surface Laptop Studio 2
  • Copilot for organizations
  • Copilot for personal use
  • AI in Windows
  • Explore Microsoft products
  • Windows 11 apps
Microsoft Store
  • Account profile
  • Download Center
  • Microsoft Store support
  • Returns
  • Order tracking
  • Certified Refurbished
  • Microsoft Store Promise
  • Flexible Payments
Education
  • Microsoft in education
  • Devices for education
  • Microsoft Teams for Education
  • Microsoft 365 Education
  • How to buy for your school
  • Educator training and development
  • Deals for students and parents
  • AI for education
Business
  • Microsoft AI
  • Microsoft Security
  • Dynamics 365
  • Microsoft 365
  • Microsoft Power Platform
  • Microsoft Teams
  • Microsoft 365 Copilot
  • Small Business
Developer & IT
  • Azure
  • Microsoft Developer
  • Microsoft Learn
  • Support for AI marketplace apps
  • Microsoft Tech Community
  • Microsoft Marketplace
  • Marketplace Rewards
  • Visual Studio
Company
  • Careers
  • About Microsoft
  • Company news
  • Privacy at Microsoft
  • Investors
  • Diversity and inclusion
  • Accessibility
  • Sustainability
California Consumer Privacy Act (CCPA) Opt-Out IconYour Privacy Choices
  • Sitemap
  • Contact Microsoft
  • Privacy
  • Manage cookies
  • Terms of use
  • Trademarks
  • Safety & eco
  • Recycling
  • About our ads
  • © Microsoft
  • Share to LinkedInShare on LinkedIn
  • Share to FacebookShare on Facebook
  • Share to XShare on X
  • Share to RedditShare on Reddit
  • Share to Blue SkyShare on Bluesky
  • Subscribe to RSSShare on RSS
  • Share to EmailShare on Email