Save multiple copies?

[ssc]

Is there a way to save more than 1 copy of an excel
spreadsheet (like in a shared network drive area) as read
only and have that spreadsheet linked to update
automatically when the original is updated?

 

[Dave Peterson]

I bet you could do it with formulas:

=if([book1.xls]sheet1!a1="","",[book1.xls]sheet1!a1)

And when book1.xls is closed.
=IF('C:\My Documents\excel\[book1.xls]Sheet1'!A1="","",
'C:\My Documents\excel\[book1.xls]Sheet1'!A1)

And copy it to the right and down (for each worksheet).

But why bother. Why not just keep the workbook readonly and let the users open
the original in readonly mode? It seems a lot simpler to me.