“Change Source” Button Greyed Out in Power Query Editor on O365 Excel

Hi WinLou ,
According to your description, change source is not available when you connect to the html of the web, this is because the purpose of the change source button is to facilitate changes from the same type of data source. For web source, there is no data on the web that can be read directly, but it is parsed to summarize the content on the web, so there is no case to change the data source. If you want to get information from another web page, you can change your url in the edit field of the m code.

How to change source data location in Power Query (7 ways) (exceloffthegrid.com)

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly