Microsoft 365 and Office | Excel | Other | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Partial screenshot
.
EXCEL STOCKHISTORY FUNCTION NOT WORKING
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 71%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Shane J
10
Reputation points
Hi, I have been writing a spreadsheet for an investment group, all was fine until Monday, I'm now not able to refresh the data. I keep getting the message that the server is having temporary problems. This is obviously causing me issues. Is this correct or am I doing something wrong?
In addition, the stock XLON:GGP is returning the wrong price, the company had a change of name and funding in June 25, the price shown relates to this date. I have checked the ticker and it is the same, but the current price is very different, what do I do?
Microsoft 365 and Office | Excel | Other | MacOS
5 answers
Sort by: Most helpful
-
Shane J 10 Reputation points
2026-02-18T13:36:11.83+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 56.00000000000001%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
David S in socal 215 Reputation points2026-02-19T01:03:23.1966667+00:00 This has been popping up frequently. Often enough that it is almost expected.
Using Excel for looking for stock data has become the equivalent of hiring a guy with Tourette syndrome to give your company's speeches. It might work sometimes, but when you need it...What would be very helpful would be MS actually saying what is making this so hard for them to fix. But that won't happen because they don't acknowledge that it is happening, or even let anyone know when they fixed it.
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 72%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Sumit D - IA 161.1K Reputation points Independent Advisor2026-02-19T14:21:42.0166667+00:00 Hi Shane,
I think waiting for a few hours would be great. I am hopeful it would be resolved.
-
Shane J 10 Reputation points
2026-02-18T12:47:25.15+00:00 Just to add further information.
Adjacent to the cells with the issue, the error is indicated as a non-trading day.
-
Shane J 10 Reputation points
2026-02-18T10:58:13.29+00:00 Hi, I'm working from home, so I only have home Wi-Fi and an Ethernet connections. Not sure if that helps. I tried both, but there's no difference. Everything else is working ok.
The problem began on Monday; up until then, no issue whatsoever.
The stock's 'current price' and related data appear to be fine, but the STOCKHISTORY function used to look up the price one month ago appears to be the issue.
-
Sumit D - IA 161.1K Reputation points Independent Advisor
2026-02-18T10:44:50.6133333+00:00 Hi Shane,
It happens a few times due to a backend issue, however I haven't seen reports of it lately. May I know if you have tried a different network, to rule out a network issue?
I’m eager to hear back and work together to find a solution.
-
David S in socal 215 Reputation points
2026-02-19T00:55:37.4866667+00:00 It's baaackk.
2/16 to 2/18 excel is giving a message that they are so sorry, but server is once again having 'trouble"
As shown on the screenshot above MS readily admits that they are having a 'server issue'. Maybe they need to take that server to therapy. It seems to have many 'issues'.The problem is absolutely NOT with network or anything else. MS just can't seem to get whatever servers are handling this to work properly. Maybe they need to hire someone with experience rather than let a middle school student try to fix it.
THIS HAS BEEN GOING ON SO LONG THAT THEY CAN'T QUITE CALL IT AN INTERMITTENT PROBLEM ANYMORE.
-
Shane J 10 Reputation points
2026-02-19T13:56:41.59+00:00 Now working.
Just need to get the ticker data for XLON:GGP updated now, any thoughts on how this can be done? I have raised a complaint, but nothing has happened yet.
Sign in to comment -