Save all your work (many interim saves, if you're like me).

Then use windows explorer to copy your template from the local drive to the
network folder.

You could use some macro approach to update both copies, but I would think that
would be too scary. If I have 3 hours of changes to make, I'd only want to
share the last version--not the intermediate saves.



bricetune wrote:

I am trying to set up an Excel spreadsheet and have it be a "master template"
and also have a network version accessiable to other office users. How can I
make sure that the changes that I make on the local master are transferred to
the network version?

--

Dave Peterson