Sounds like you're using Genki. Look at page 77, it's explained there:
So indeed, *normally* で is used for things that happen at a location while に is for things that go toward a location, but います/あります make an exception. They use に to indicate the location even though the action consists of merely being present there.