I have a single PivotTable that pulls data from a different worksheet in the same workbook. The data it is pulling is updated every 30 seconds through Bloomberg's API. I want to update the PivotTable automatically on a periodic basis, but the "Refresh every X mnutes" box on the PivotTable options page is greyed out. I have the same problem If i change the Bloomberg refresh option to "immediately". Can someone help me? Thx.