Refresh not working for pivot table/chart. "This command requires at least two rows of source data. you cannot use the command on a selection of only one row. Try the following" If you're using an advanced filter, select a range of cell that contains at least two rows of data. then click the Advanced Filter command again. If you're creating a PivotTable report or PivotChart report , type a cell reference or select a range that includes at least two rows of data
Solved by F. H. in 22 mins