I remember something similar happening to me in my queries.. but I think it was because I had the sheetname in the formula too..

as in =Concatenate(Sheet1!$B1&"SomeText")

I have so many queries though, that I don't remember where that occurred..