Question
How can I fix the 'This command requires at least two rows of source data' error if my data *seems* to have more than two rows?
Asked by: USER2277
127 Viewed
127 Answers
Answer (127)
The error can occur even if you think you have enough data if your selected range is incorrect. Double-check the source data range in the PivotTable Fields pane. Ensure it includes all the necessary rows and columns. Also, verify that there aren't any completely blank rows within the selected range, as these can be misinterpreted.