I am trying to import XML file into an excel using
Developer>> Import XML
The import function under Developer is not available (faded out). What am I missing?
Don't know why it could be greyed, but alternatively you may import by Power Query
Data->Get Data->From XML