hi,
"Is there any way to get rid of this?"
This is like saying, "I woke up this morning, looked out my window, and discovered a brand new Lexus, with a bow and a note telling me that this is a gift to me!"
"Is there any way to get rid of this?"
I can understand you asking, "what is this [@zzz] stuff that gets into my formula?" but why would you simply dis it?
I think its pretty kool stuff! Fact is just yesterday I had inserted an MS Query in a sheet AND had added several columns of formulas and subliminally noticed the @. When I read your post this morning, the light went on. Excel version 2007 (into which I went like Linus dragging my Excel version 97-2003 blanket) and after days of struggle discovered a vast vista of new features, the BEST, IMHO, being Structured Tables. Well THIS feature with the [@zzz] references is a new feature of Structured Tables.
Here's s little "experiment:"
Select in your QueryTable. Notice that in the Ribbon a new Context Sensitive TAB pops up called Table Tools Design. SELECT the Design TAB and notice the Table Name in the Properties GROUP. Its a DEFAULT name. I often change it to something that is meaningful. Theres a WHOLE LOT of good stuff to discover in the properties within this TAB.
When you enter a formula ANYWHERE in the workbook and refer to this table name, lots of good stuff happens! So enter an =, followed by the Table Name (notice Intellisense lists the available names beginning with what you have begun to type) when you have your name het TAB and [. VOLA Y'all! And there, at the bottom of that list is the @ and an explanation!!!
Now ain't that some good stuff, just for starters?
Of course, if you still want to get rid of it, just use regular A1 referencing. But you LOOSE a lot of really useful features. AND a Lexus is downright fun to drive! ;-)
