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.

 

[SydneyGeek]

Assuming that the data table starts in A1, Sheet1 you could do something like:

Sheets("Sheet1").Range("A1").CurrentRegion.Calculate

Denis

 

[jrmunge]

Assuming that the data table starts in A1, Sheet1 you could do something like:

Sheets("Sheet1").Range("A1").CurrentRegion.Calculate

Denis

That was fast! Thanks Let me try it out i'll get back to you.

 

[jrmunge]

Seems like it didn’t work. The datatable still remains unrefreshed

 

[SydneyGeek]

Sorry, I was thinking recalculation rather than refreshing a table. Try...

Sheets("Sheet1").Range("A1").Select
ActiveWorkbook.RefreshAll

Denis

 

[RoryA]

If you only have one table, f9?

 

[shivgan3]

This did not work at my end, I want to refresh a data table selectively from a workbook which has 12 datatables.
Is that possible?

Sorry, I was thinking recalculation rather than refreshing a table. Try...

Sheets("Sheet1").Range("A1").Select
ActiveWorkbook.RefreshAll

Denis

 

[shivgan3]

Proposed Strategy, using VBA:

Step 1 delete all tables but not the table you want to refresh
Step 2 refresh sheet
step 3 restore all table that you deleted

This did not work at my end, I want to refresh a data table selectively from a workbook which has 12 datatables.
Is that possible?

 

[Lawd Potato]

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 did not work at my end, I want to refresh a data table selectively from a workbook which has 12 datatables.
Is that possible?

 

[RoryA]

A data table is not the same as a Table (Listobject). The former is comprised of a grid of =TABLE() formulas.