ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Multiple users updating the same spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/98378-multiple-users-updating-same-spreadsheet.html)

Wamari

Multiple users updating the same spreadsheet
 
I would like to know if it is possible to have several users on a network
updating the same excel spreadsheet on a server.

JLatham

Multiple users updating the same spreadsheet
 
See the Excel HELP topic "Share a Workbook" which gives these instructions
plus some more information:
------------
Share a workbook
Show All
Hide All
Create a workbook you want to make available for multiuser editing, and
enter any data you want to provide.
If you want to include any of the following features, add them now: merged
cells, conditional formats, data validation, charts, pictures, objects
including drawing objects, hyperlinks, scenarios, outlines, subtotals, data
tables, PivotTable reports, workbook and worksheet protection, and macros.
You can't make changes to these features after you share the workbook.

On the Tools menu, click Share Workbook, and then click the Editing tab.
Select the Allow changes by more than one user at the same time check box,
and then click OK.
When prompted, save the workbook.
On the File menu, click Save As, and then save the workbook on a network
location accessible to the intended users. Use a shared network folder, not a
Web server.
Check any links to other workbooks or documents, and fix any that are broken.
------------------

"Wamari" wrote:

I would like to know if it is possible to have several users on a network
updating the same excel spreadsheet on a server.



All times are GMT +1. The time now is 07:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com