How to share an Excel spreadsheet between multiple users
I work for a small firm & i want to know the is there any tool in Excel or any third party software available for excel spreadsheet so that we can view an Excel spreadsheet document at the same time in our office?
Actually i want all the users to be inthe same document & saving changes.
Is this possible? If it is Please let me know about some more information regarding this!
To share an Excel spreadsheet
To share an Excel spreadsheet, select Share Workbook under the Tools menu.
When the Share Workbook window appears, click on the checkbox to allow changes by more than one user at the same time.
Click on the Advanced tab. You can then customize the options. Click on the OK button.
The following message should appear. Click on the OK button.
Now when you return to the spreadsheet, you should see [Shared] at the end of the file name. This indicates that the Excel file is set up as a shared workbook.
Is there any solution if we want to share this spreadsheet with users from same domain but at different location. Members will have the permission to look at this document but can't edit it except those who are given the permission.
Is it possible?
Doing this with Excel is *begging* for trouble--shared workbooks are especially prone to file corruption, and it is best to avoid that "feature".
Google Spreadsheet is supposed to be able to do it.
Do you have the ability to use Webex or Live Meeting or some other online meeting service? That would allow everyone to "see" the spreadsheet while still allowing just one person to "drive"...
Re: How to share an Excel spreadsheet between multiple users
You can Using Add-in A-Tools
To share Excel data files for multiple users on the network, Excel ‘s way is only share full folder that contains an Excel files. In this way, the computers in your network can access the copy and even completely remove this data file. The owner of this Excel files can only share all sheets in workbook (file) the whole it is difficult to hide the sheets or prevent others from seeing data. Other requirements as allow users access to the data but has the rights: read only, edit, limit how many people are connected ,.... Excel can not do it.
A-Tools is an add-in run in Microsoft Excel environment. A-Tools has the following functions:
A-Tools running on versions of Excel 2000/XP/2003/2007/2010.
Last edited by Maqbool : 08-06-2011 at 02:26 PM. Reason: External links not allowed
|Tags: excel spreadsheet, multiple users|
|Thread Tools||Search this Thread|
|Similar Threads for: "How to share an Excel spreadsheet between multiple users"|
|Thread||Thread Starter||Forum||Replies||Last Post|
|How to link multiple spreadsheet inside a single sheet via VBA||cupid!||MS Office Support||6||24-02-2012 12:50 PM|
|Can We Auto-Run Excel Spreadsheet.??||Dilbert||Windows Software||4||02-01-2010 08:09 PM|
|add Checkbox in Ms Excel spreadsheet||Novino||Windows Software||4||02-09-2009 09:43 PM|
|Importing Excel Spreadsheet||Theodore Long||Microsoft Project||3||05-06-2009 09:02 AM|
|How to prevent users from deleting Word/Excel files in a Share?||SidharthGore||Windows Security||3||16-05-2008 11:19 PM|