Refresh data table via vba????

[jrmunge]

Hi,
Can anyone help me out with a code on how to refresh a data table via vba. My workbook has been set to automatic recalculation(except data tables) due to speed issues. I need to have a macro that I can call whenever I want the data table refreshed. Please help me out.

 

[Intermedius]

I understand that this thread is old, but Google got me here and what I ended up finding elsewhere may be helpful to others here:

Worksheets("SheetNameHere").ListObjects("TableNameHere").Refresh

Will this work on a table that is fed through a CSV file, or even an excel file in a folder? My code is pulling data from another source and trying to update an existing Excel Table, but i get the "Unable to add data to existing table error" (Not verbatim).

Trying to figure out a way to refresh My table without having to delete it and start new, because My existing table had important formula columns using Excel table "structured formulas". I've even tried using and updating queries in the data model and no luck.

 

[SlightlyTrashy]

I understand that this thread is old, but Google got me here and what I ended up finding elsewhere may be helpful to others here:

Worksheets("SheetNameHere").ListObjects("TableNameHere").Refresh

this is what I was looking for ty