External Data Refresh Failed

Hi JohnKendig1,

Thank you for querying in this forum. We do understand the inconvenience caused and apologize for it. And we will try our best to help you.

According to your description, it seems that you have an spreadsheet and linked to external data, and it worked before, however, now it refreshed failed and encountered an error message.

May I know if my understanding is right? If so, we have tested it on our side, we just created two workbooks and linked the data from one workbook to another workbook, and it refreshed data without any problem.

May I know if the steps above are consistent with yours? If not, could you provide the detailed steps about how you linked to external data?

At the same time, to better understand your situation and provide specific suggestions, could you provide the information below?

1. Could you provide the screenshot of error message?
2. Could you provide the Product information and version of your Excel? You can go to Excel > File > Account and provide the screenshot of it. 
3. May I know if you linked external data from another workbook or stock quotes from web page?
4. May I know if all files have the same problem? You can create a new Excel file to check if the same problem will occur.

Best Regards,

Sukie

Hi JohnKendig1,

May I know if you have seen my reply? May I know if you still need help? If so, you can post back and we will try our best to help you.

Best Regards,

Sukie

The data is being pulled from the "Stocks" refresh in excel.  It is being shared with other worksheets in the same Excel spreadsheet.

I have found that intermittently, say 1 out of every 10 times I attempt to "refreshes all connections" it works fine.

Unfortunatly, I can not get the error message to snip to send to you.

Hi JohnKendig1,

We appreciate that you posted back and shared the details with us. We’re sorry for the late reply due to the weekend.

We have read your description carefully, and it seems that you just created a workbook with several worksheets, and you pulled data from Stocks, and you linked the data to the other worksheets.

At the same time, this issue occurs intermittently.

If my understanding is right, we have tested again on our side with Excel, we just used Stocks to get data, then we linked the data to another worksheets, and it works fine.

Given this situation, we’d suggest you create a new workbook to check if the same problem will occur, if the same problem still persists after creating new workbook, this issue may be related to Excel client, we’d give you some suggestions below and hope that will help you:

1. We’d suggest you refer to this article: Update history for Microsoft 365 Apps to achieve the latest version of Office. Then you can update your Office to the latest version to check if the same problem will occur.
2. You can open your Excel in safe mode to check if the same problem will occur. It will help in identifying an add-in or extension that may be causing a problem on startup. As steps shown below: Right-click the Start button (lower-left corner) in Windows, and click Run.> In the Run box, type one of the command: excel**/safe**
3. You can use Online Repair to fix the Office application. Repair an Office application.

If the same problem still persists after trying the suggestions above, to narrow down this issue, could you provide the information below?

1. Could you provide the Product Information and version of your Excel? You can go to Excel > File > Account and provide the screenshot of it. As shown above.
2. Do all files have the same problem? You can create a new workbook to check if the same problem will occur.

Best Regards,

Sukie

I have the same issue - worked fine for over 18 months and then throwing a very unhelpful error - it should IDENTIFY the specific field that is causing the problem and it should IDENTIFY which data is updated and which is stale.  Very BAD implementation to update some data and not others and leave the user wondering what is good and what is bad.

I am using @Investment.Price, .Change, .[Ticker Symbol],.[change (%)] ... etc.  All the typical fields that can be pulled in from @Investment.  Obviously something has been deprecated, this question needs to get to support for the @Investment data source. 

Thx