Macro to reformat tab after importing data

Occasional Visitor

I have a repetitive task where I import XML data into an excel, and then hide certain columns, reformat other columns, sort the data.  When I try to record the macro to do all of this, no steps seem to be saved... (using Developer - RecordMacro, (execute reformatting steps) then, StopMacro.  Any ideas?