Hi, I've got a table which contains a couple of columns within the table that are populated by vlookups from another sheet. When I create a pivot table on this table it doesn't give me the option to display the columns populated by the vlookups. Is this right or can I fix it so it does? thanks, Neil
I assume your column has a heading and you've checked the source range for the pivot includes the column?
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
yes to both of those questions!
A workaround would be to copy the source data and paste special the values elswhere then use this data for the pivot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks