Sub listpivotConns()Dim ws As WorksheetDim pv As PivotTableFor Each ws In ThisWorkbook.SheetsFor Each pv In ws.PivotTablesDebug.Print (pv.Name)Debug.Print (pv.RefreshDate)Debug.Print (pv.PivotCache.WorkbookConnection)Next pvNext ws'MsgBox "Done"End Sub

function loopit_percentages() { var percentcols = ['D', 'E','F'] for (var k = 0; k<= percentcols.length -1; k++) { for (var i = 1; i<=20;i++) { var rng = percentcols[k] + i.toString() Logger.log(rng) SpreadsheetApp.getActiveSheet().getRange(rng).setNumberFormat("0.00%") }}} function…