A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hello, Kelvin Lee1
Thanks for using Microsoft products and posting in the community.
Regarding your question about Excel's stock function not pulling data from NNE properly;
I have tested this with other engineers using Excel tests, we tested e.g. Microsoft stock data and only when we try to fetch the NNE data we get an error, which is the same as the situation you described.
The source of data for Excel's stock function is mentioned in this official article:
About the stock financial data source;
The current issue should be a temporary problem with the data source, which should be fixed as soon as possible, and we have provided feedback through internal channels. I do understand the inconvenience this issue has caused you and thank you for your understanding and patience.
Best Regards,
Arthur - MSFT | Microsoft Community Support Specialist