maintain two excels at same time

Hi,

i am just narrating what i need....
just think i am maintaining a leave planner for my staffs in my desktop
but i want to maintain a excel parallely in common drive where all my staffs can have a look on it
the excel saved in common drive should automatically update when i make changes in the excel in my desktop.
how is that possible
(i cant save original excel in common drive, sometimes staff may delete that, so i need to maintain it in desktop, that is the reason i need help on this)
i am using 2007 version

thanking for efforts guys
i got the solution
i just copied the data from master workbook and pasted using paste special => paste link, in common drive work book

there is a drawback in this, i.e. in the workbook which is in common drive, it always show zero for blank cells in master excel
can't help it will be as it is
whenever you open the excel in common drive it asks permission to update. if this is uncomfortable, please go to excel options => trust center => trust center settings => external content => click th check box "enable automatic update for all workbook links"
then it will be automatically update whatever the changes happens in master workbook.