Excel - Recording a VBA macro to update PDF source file

I have an issue that I can't solve. I have a workbook that pull the table from a pdf file. This importation have already the "convertion" data. (text to numbers).

Now I want to import the data from another pdf file to the same workbook.

My steps: Data tab -> Get Data -> Data Source Settings -> Change Source (pick other pdf file) -> Refresh All

This is what I do. I already try to record this steps to a macro and create a button with this record. But the only thing that records is the "Refresh All" step. The others steps are not saved.

Is this an Excel limitation? Or there are something that I missed?

I would be very thankful for any help you can give. I hope that you can understand my question.

Best regards, Eduardo