ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Multiple Users Updating Document (https://www.excelbanter.com/excel-discussion-misc-queries/186479-multiple-users-updating-document.html)

Randy

Multiple Users Updating Document
 
I have a spreadsheet on a shared drive. Multiple people will have access to
it and will need to be able to update/save at the same time. How do I save
the spreadsheet so that regardless of how many people have accessed it, they
are able to update and save?

Thank you, in advance, for you assistance.

Randy

Randy

Multiple Users Updating Document
 
Figured it out.......Thanks!

"Randy" wrote:

I have a spreadsheet on a shared drive. Multiple people will have access to
it and will need to be able to update/save at the same time. How do I save
the spreadsheet so that regardless of how many people have accessed it, they
are able to update and save?

Thank you, in advance, for you assistance.

Randy


JLatham

Multiple Users Updating Document
 
Check out Excel Help and search for Share Workbook or Sharing a Workbook.
The basic how to set it us is:

Tools | Share Workbook [Editing] and select "Allow changes by more..."

You'll also want to read other topics about sharing workbooks, such as
features that are not available so you'll be ready for any questions.

Hope this helps at least a little.


"Randy" wrote:

I have a spreadsheet on a shared drive. Multiple people will have access to
it and will need to be able to update/save at the same time. How do I save
the spreadsheet so that regardless of how many people have accessed it, they
are able to update and save?

Thank you, in advance, for you assistance.

Randy



All times are GMT +1. The time now is 02:23 PM.

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