How to change source name? Trying to point table at other source keeps giving error?

[pete234]

I imported a table from a workbook on my desktop from a sheet called "Sheet1" to a table called DataNew.
I was testing formula.
Now I want it pointed back at my shared drive workbook that has a table called DataNew.
I changed the connection to point at that workbook.
Now it keeps telling me "Sheet1" is not valid name if I try to refresh.
But why is it keeping that name if the power pivot table isn't even named that?
How can I rename the source? When a window pops up it tells me I can change the name but the option to save is greyed out.
I can only close it out. I've changed sources before so not sure what's going on.
Any advice?

I tried to rename the destination import to "Sheet1" and got a different error saying one or more parameters was not supplied.
I'm trying to save myself redoing all of these formulas and the very specific order I need this data.

 

[pete234]

Ok I fixed it. The option was greyed out because I was trying to type in a new name when I had to select from the list. This was under Table Properties.