the table on it and I select the data I need...it stopped doing this...when I select insert and then pivot table all it does is select the range in my current sheet??? How can I fix this?