"Play sound at location" is not working properly

I’m not sure, but if you are using the WAV file as your sound and not the CUE, I’d find the WAV in the content browser, open it up and check if the attenuation has been overridden and given some sort of range.