Editing Range Referencing

[dsexpress]

Can I edit named ranges so I don't have this attached message displayed each time I import this sheet?

[ChemistB]

Not sure exactly how you are importing the worksheet but try this and see if it makes a difference;
When defining the name using Insert>Name>Define Name, preceed the name with the sheet name e.g Sheet1!Table1. I've found that prevents issues when I am moving sheets between workbooks. Let me know if this works. It will also make it so that name is only used on that worksheet so if you reference that defined name from other worksheets, you might need to manipulate.