Excel's stock data type can't find several stock exchange indexes (i.e: FTSE, CAC 40, Hang Seng...)

I noticed by searching around that this is a topic that has been asked quite a bit with no clear answers that get to bottom of this issue.   I'm well aware the Excel data types feature is still a w...