W
wojo
I would like to have only one, maybe two computers on the network, have
the ability to open the Excel file with read and write capability. I
want all other computers on the network to have the ability to open the
file in a READ ONLY status. I do NOT want the user to have the option
of read only.
Because I don't know if this can be done, I have made a "linked" file,
which is read only, for users on the network. This works OK, but my
file has forumlas with don't work on the linked file, without
converting the links to values. I want the networked users to be able
to manipulate the data (so they can check out different numerical
scenarios). I made a macro that opens the original file, copies the
formulas, then pastes the formulas onto the read only file. This
allows the data to calculate when the user changes the value of cells.
To ensure the user does not create numerous "copies" of the read only
file, I have a BUTTON on the sheet, that closes the file, without
prompting the user to save.
Is there a better way? Can the original file be made read only, for
networked users?
Thanks in advance. Jo
the ability to open the Excel file with read and write capability. I
want all other computers on the network to have the ability to open the
file in a READ ONLY status. I do NOT want the user to have the option
of read only.
Because I don't know if this can be done, I have made a "linked" file,
which is read only, for users on the network. This works OK, but my
file has forumlas with don't work on the linked file, without
converting the links to values. I want the networked users to be able
to manipulate the data (so they can check out different numerical
scenarios). I made a macro that opens the original file, copies the
formulas, then pastes the formulas onto the read only file. This
allows the data to calculate when the user changes the value of cells.
To ensure the user does not create numerous "copies" of the read only
file, I have a BUTTON on the sheet, that closes the file, without
prompting the user to save.
Is there a better way? Can the original file be made read only, for
networked users?
Thanks in advance. Jo