Excel on an Intranet

  • Thread starter Thread starter cmh
  • Start date Start date
C

cmh

I have an excel spreadsheet available on the intranet for
several users to update. When one user has it open there
is no message sent to other users warning them that it
can't be opened. Everyone can open it at once and then
save it - which of course means changes being lost. How
do you force only 1 copy to be opened at a time?
 
If users access Excel file via URL the changes they make are saved on the client (their workstation). You should come up with different solution if you want them to be able to save changes to the file on the server.
I would create a shared folder with the file located in it.
 
Back
Top