I have made the most simple of pivot tables simply so that I can use all the fields with another one in a powerpivot but keep getting this error message:
'The selected range is invalid. Select a valid range. A table cannot overlap a range that contains a PivotTable report, query results, protected cells or another table'
Is this a common error? I'm thinking this is probably something simple? Any pointers appreciated!
'The selected range is invalid. Select a valid range. A table cannot overlap a range that contains a PivotTable report, query results, protected cells or another table'
Is this a common error? I'm thinking this is probably something simple? Any pointers appreciated!
