Excel on an Intranet

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?
 
O

OG

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Embed the same Excel multiple times 0
Word 2016 opening sooo slow 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
sqlite-odbc write conflict 2
Spreadsheet will not open from Intranet Link 0
Language of the templates 0

Top