Dear all,
When I am doing data excel and try to use "Recommended PivotTable" there is an error "The range you picked can't be used as a data source. To create a PivotTable, you need to use a range that is organized as list with labeled columns". I try to goggle the solution but still did not make it.
excel pivot.JPGexcel pivot.JPG
On the screenshot we cannot see the top row of selected area, but probably there is no labels (unique names of columns) in all cells of this row.
In ALL columns - also these where is no data present. It can be any word like on my screenshot, but has to be present (an has to be unique, so if you have more empty columns you couild use emty1; empty2; empty 3; and so on
Best Regards,
Kaper
Dear Kaper,
Thank you the reply
I do put the data on columns but still get and error.
Attachment 735708
Cannot open your attachment.
See the yellow banner above - how to attach files
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks