Hi
I have made a sheet at home that put data into specific section for example any thin that has GRI in the txt it falls under GRI in the pivot - my issue is when I try use it at work 2007 excel I can still see the pivot but when I double click on any of the totals it does not work ( it should bring up new sheet with the data)
formula is in the raw data dab column I = =IFERROR(LOOKUP(1000,SEARCH($J$2:$J$19,H2),$J$2:$J$19),"OTHER")
is there any fix for this
ta
Bookmarks