I have created a Pivot table from a text file. When I click on Refresh Data on Excel, because I have updated the text file, the following error appears.

[Microsoft][ODBC Text Driver] Too few parameters. Expected 1.

Which leaves me creating another Pivot Table again?

Why doesn’t the Refresh Data button work?

Thanks in advance

As the error message says it seems that you don't have any parameters seted up for your pivot table