Data types not loading in Excels data selector (change data type)

Question

when I use the "stocks data" function to get real time commodity prices ie gold and silver for a spreadsheet, when trying to change data type and "see more results" it doesn't load any results.

*picture attached*

using a 2020 MacBook Pro with the latest version of Excel

as you can see the data selector never loads the results.

Answer 1

Hi Hi bradwoodward,

We appreciate your understanding that sometimes the initial suggestions may not resolve the problem very soon. However, we can work together to narrow down and resolve the situation.

Yes, you are correct, it seem when I click on "see more results" button on the bottom of data selector in Excel even in Newley created file and I go the same result like yours. See image below for your reference:

Since I can confirm I also the meet same behavior as like yours(reproduce) now, in this scenario, to report this issue to related Microsoft Excel development team, I request you, please provide the feedback via our Microsoft Excel feedback portal, to related development team so that it will be fix in next update of Office version for Mac OS and they can get notice about it. It’s the best way to report to related development team and we are sure it will speed up this process. Your advice is very important to us

I appreciate your understanding and stay safe!!

Best Regards

Waqas Muhammad

Answer 2

Thanks for the quick response

I get the same result when I use the data it is when I use the "see more results" button on the bottom I get this

and it never loads

thanks

Answer 3

Hi bradwoodward,

First, my pleasure to assist you.

As per your description, please don’t worry, we can work together to narrow down and resolve the situation.

Based on my test in Excel version 16.57 and it seems I cannot meet same behavior as like you described above. See image below for your reference:

May I know does this issue happened to a specific Excel workbook? If you don’t mind, (I request please don’t mind) could you please create a new Excel file for test purposes and check whether you meet same under data selector. It will help us to narrow down your issue.

Meanwhile, please feel free to confirm your Excel and MacOS version.

I appreciate your understanding and stay safe!!

Best regards

Waqas Muhammad