Excel/Pivot Table - auto refresh how?

I'm loading an excel spread sheet with an embedded pivot table. Getting the excel work book to load is easy, but it seems to require that you manually "refresh data" after the workbook loads. The spreadsheet automatically imports new data from a text file, but the new data doesn't show until you manually refresh...

I'm loading the workbook like this:

sFile = "d:excelstuffpivot.xls"
set xlWorkBk = xlApp.Workbooks.Open(sFile)
xlApp.visible = true

easy as pie, right? How do I make the pivot.xls automatically refresh the cell contents?
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!