External Data Refresh Failed

Hey! I just figured it out. In my master workbook, I have a ton of tabs but each client's stocks are tied back to one master worksheet. I copy/pasted all of the symbols on that spreadsheet into a new spreadsheet, then deleted all of the stocks on that master worksheet that has been giving me an error and made them "general format" instead of "stock format". Then I copy and pasted all the symbols back where I want them, made them "stock format" again, refreshed all and it worked! Phew! So, I recommend going to each place where you have a stock that is formatted and then try this, the redo that part. It took me like 3 minutes once I figured it out and all of the 100+ client worksheets that are formatted back to that worksheet, still had the same formulas so everything was fixed and spared. Hope that helps!

Hello,

I on the other hand found this to be helpful. I opened up a new spreadsheet and tested it briefly and did not get this error after pressing "refresh all". Now is my question, how do I correct whatever is wrong in my current spreadsheet without starting all over? Because I continue to get the same error in my current spreadsheet. This is an issue because I track everything for many clients in this spreadsheet and there are over a hundred worksheets within the workbook that is giving me this error. I need to find out what is not updating and I need to correct the issue within this workbook. It would take me me a month or two to completely redo everything in a new spreadsheet.

I'm glad you got it solved.  The problem for me is that my document has thousands of stock fields in it.  So there is no way I can delete all the "stock" fields and then re-input them.  that would take me days.  But I'm glad at least someone in this forum has found a solution :-)  Also, maybe microsoft can see your experience and use that to figure out how to solve this on their end for all of us.  🙏🙏

Very interesting.  I opend a totally blank spreadsheet and added one stock and next to it the stock price.  No error message!   So then I added a 2nd, 3rd, 4th, all the way up to the ten stocks in my master spreadsheet.  No error messages!  But my master spreadsheet with the same 10 stocks throws an error message every time I click refresh even though the ten stocks are updating correctly.  Very strange!

When I have a bit more time later today, I will go into my master spreadsheet and delete all the stock data cells, then re-add them one by one to see if that eliminates the error message.  I will post the results on here when finished.

seems to  me, good customer service would not be to suggest your client to:   "report this issue to our related team" but for YOU to report the issue to the related team, explain and detail to the "related team" the work you have done to try to resolve, and include the client on the correspondence.  Then, if the "related team" assumes responsibility for the problem, consider the matter appropriately transferred.  Your thoughts on this?

Thank you.