Hi @sudster - thank you for your response. I skimmed through the link you shared and it looks like it might not work with dynamic Excel file paths. Please correct me if I’m wrong. My use-case involves downloading .xlsb files and then reading the pivot table in a worksheet (table range B6:C, there is data in other columns in the same sheet, the pivot table row count can go up to 100K also).