Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to share an Excel spreadsheet between multiple users

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 14-08-2008
Member
 
Join Date: May 2008
Posts: 31
How to share an Excel spreadsheet between multiple users
  

Hi,
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!
Thank you.

Reply With Quote
  #2  
Old 14-08-2008
Member
 
Join Date: May 2008
Posts: 30
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.
Reply With Quote
  #3  
Old 14-08-2008
Member
 
Join Date: Jun 2008
Posts: 81
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?
Reply With Quote
  #4  
Old 14-08-2008
Member
 
Join Date: May 2008
Posts: 12
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"...
Reply With Quote
  #5  
Old 14-08-2008
Member
 
Join Date: May 2008
Posts: 63
I think this software is useful to you guys!
Reply With Quote
  #6  
Old 14-08-2008
Member
 
Join Date: May 2008
Posts: 56
Ap per my openion don't use Excel and instead put together a little simple Access database.
Reply With Quote
  #7  
Old 08-06-2011
anhquyhaui
 
Posts: n/a
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:
  • Create & Manage Server (Excel Server)
  • Create ranges in worksheet for sharing on the network
  • Build Groups and Users to access/connect to
  • Setup rights for groups
  • Manage list of users connected
  • Connect to the Excel range to read/edit/format
  • Functions support for editing and updating data on server
  • Management Excel reports on the network (LAN), support commands: Check; Approve; Dis-Approve. Under each command the user is not allowed to copy data, printing, modify report.
  • Query data on worksheet
  • Connect to the external database: Excel, Access, MySQL, Firebird,…
  • Create dynamic report
  • Build query formula BS_SQL() by “SQL Builder”
  • Create function for Function BS_SQL()
  • Query and linking data to Server by BS_SQL() function

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
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 05:21 AM.