share exel doc while on a local offline network

[Sam Pearson]

hello is there a way i can share an excel doc on a local network without a server were 1 laptop is the editor and multipule ipads/tablets can view this in real time or would it have to be like a teamviewer thing or screen share thing.

 

many thanks in advance 

 

sam

[AdamBGames]

2 minutes ago, Sam Pearson said:

hello is there a way i can share an excel doc on a local network without a server were 1 laptop is the editor and multipule ipads/tablets can view this in real time or would it have to be like a teamviewer thing or screen share thing.

 

many thanks in advance 

 

sam

Excel and Google Sheets both have this already, you just need to share the file with another user's Microsoft account, and then they will be able to work on the file same as you, or just read it if you want to

[DrMacintosh]

Microsoft 365 allows for collaborative editing of the same document. Without Microsoft/Office 365 you cannot open the same document on multiple devices. 

[Sam Pearson]

1 minute ago, AdamBGames said:

Excel and Google Sheets both have this already, you just need to share the file with another user's Microsoft account, and then they will be able to work on the file same as you, or just read it if you want to

even when there is no internet connection as i find that it doesnt work unless you have the internet attached to the network 

 

[Sam Pearson]

3 minutes ago, DrMacintosh said:

Microsoft 365 allows for collaborative editing of the same document. Without Microsoft/Office 365 you cannot open the same document on multiple devices. 

i find i cant do this unless i am connected to the internet i would like to know if there is a way to do this on an offline netowork

[Electronics Wizardy]

Do you need excel?If yes, I'm pretty sure there isn't a way to do this.

 

There are self hosted google drive/m365 solution you can run offline, look at only office.

[Sam Pearson]

18 minutes ago, Electronics Wizardy said:

Do you need excel?If yes, I'm pretty sure there isn't a way to do this.

 

There are self hosted google drive/m365 solution you can run offline, look at only office.

thanks i will have a look 

 

[Needfuldoer]

If all the machines on this island network have Excel (or the spreadsheet application in LibreOffice, etc), you can just share a folder and drop the file there. It won’t update in real time, but I don’t know of a way to do that without spinning up a web server for a tool like OnlyOffice. 

[LAwLz]

59 minutes ago, Needfuldoer said:

If all the machines on this island network have Excel (or the spreadsheet application in LibreOffice, etc), you can just share a folder and drop the file there. It won’t update in real time, but I don’t know of a way to do that without spinning up a web server for a tool like OnlyOffice. 

It won't work because OP wants to edit the document at the same time. 

 

When Excel opens a document it locks the file so that nobody else can edit it. There is a way around it, but the way that works is that excel loads a copy of the document and edits that. You won't be able to save to the original file, and even if you could, it would constantly overwrite the edits done by everyone else. 

 

OP, there is no way to do this. Only the web version of Excel has the necessary features to let multiple people edit the same document at the same time. Your only options are to use excel online (or a program that uses excel online, like Teams), or use a completely different solution (but that most likely require an online connection too). 

[Needfuldoer]

7 minutes ago, LAwLz said:

It won't work because OP wants to edit the document at the same time. 

Shared workbooks might get close to the intended functionality, so long as everyone's running Excel.

 

https://support.microsoft.com/en-us/office/about-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534

 

https://learn.microsoft.com/en-us/office/troubleshoot/excel/use-shared-workbook

 

 

[Sam Pearson]

thanks for all your help guys !