Save multiple copies?

  • Thread starter Thread starter ssc
  • Start date Start date
S

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?
 
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.
 
Back
Top