Excel on network

  • Thread starter Thread starter John
  • Start date Start date
J

John

At work we have the Excel program installed on the individual computers and
the xls files on a common file server.
If you are the first person to access the files you can make changes and
save. Any other users get access to the same files in READ-ONLY mode.
How can I make it so the files can be opened, altered, and saved by any
user regardless of who has the file open first?
Thanks
 
Hi
have a look at 'Tools -Share workbooks'

note: this will restrict Excel's functionality
 
Back
Top