convert data on sheet to table getting error
i have data on a sheet which i m trying to convert to table using this code but i get error "a table cannot overlap with a pivot table report query results protected cells or another table"
The first row on the sheet named Data has the headers
how do i fix or bypass this error
Please Login or Register to view this content.
Last edited by littleangel; 09-05-2023 at 12:49 AM.
Move whatever is causing the obstruction.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
kindly elaborate...i checked the named range , it doesnt have such table or range if thats what u mean
The error message mentions query results and protected cells, did you check for either of those?Originally Posted by littleangel
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
i solved this....i simply created a sub to copy the data n create new sheet and pasted it and then created table and it resolved the issue. ...thank u
Then you should have shared the solution and marked the thread as SOLVED for the benefit of the community.
and i would have later in the day today ... we r in different timezone and its still early morning here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks