I am selecting insert to do a pivot table...normally when I select this it opens a new sheet with?

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

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?

or: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?

Tags:table,range,