Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Share Spreadsheet

Sharing a spreadsheet allows several users to open the same file for editing at the same time.

To access this command...

Choose Tools - Share Spreadsheet

The spreadsheet needs to be on a shared drive, server, website, or similar. Some conditions must be met on operating systems with user permission management:

  • The shared file needs to reside in a location which is accessible by all collaborators.
  • The file permissions for both the document and the corresponding lock file need to be set so that all collaborators can create, delete, and change the files.

In order to correctly identify the changes, each collaborator should enter their name in Tools - Options - Office - User Data on the Menu bar.