I had the same issue since everywhere it tells you to go to add ins but it is
just not there. Insert the CD you got from Microsoft and it will allow you to
repair delete or add ins choose the later and you will see the data tool pack
option under Excel.