How can I link two workbooks together

[OfficeChick]

I have a master workbook that only I have access to. I would to have a copy
of it for viewing purposes only, except when I make changes to the master
one, changes are not made on the copied one. I think I didn't link them
correctly. I would like to know the proper way to link an entire workbook to
mirror the other?

 

[Peo Sjoblom]

It seems your subject contradicts your question, if you don't want changes
to be done in the copied one then you shouldn't link them. Just make a copy
either by

Save as myworkbook_copy.xls

or go to the folder and right click it, select copy then paste
and you don't even have to rename it, windows will do that for you

--


Regards,


Peo Sjoblom

 

[Jim Thomlinson]

Probably the easiset way to do this will be to password protect the workbook
when you save it as opposed to making a copy or linking.

File -> Save As -> Tools -> General Options and add a password to modify...
Your users will be able to view the file but they will require a password to
modify the file.