how does the personal.xls file get updated?

i thought everytime i made a change in excel macros that the personal file
was updated. i discovered today that is not true.

how do i control where the file can be located? want to put a common macro
library on the server for several people to use
how do i ensure that the file is updated correctly?

thanks