+ Reply to Thread
Results 1 to 1 of 1

Collaboration in Excel (SharePoint & common base - how to?)

  1. #1
    Registered User
    Join Date
    03-16-2012
    Location
    Russia
    MS-Off Ver
    Excel 2010
    Posts
    98

    Collaboration in Excel (SharePoint & common base - how to?)

    Good afternoon. Traditionally - please excuse my english. And please suggest a solution for my situation.

    1. SharePoint. The implication is that has Excel file that everyone can to download and work with one common base. The results should be stored in a common database, which is a very large table;
    2. The possibility of logging employees actions;
    3. The ability to lock change (view only) some columns or ranges;
    4. ~500k rows, ~50 columns, ~50 people at the same time may work with the file.

    As far as I know, there is a possibility to load the database access to excel. But please advise the best solution. So that employees can work with a common base, the result would be recorded in the one common single table (1 database/1 excel table).

    Ideally, we can enjoy and Access, but not all colleagues own formulas for Access, many habitual use excel formulas (like vlookup etc. etc...
    for example, to use the VLOOKUP to a shared file, comparing it with their local files)

    How to get out gracefully in this situation? I believe that the work Excel, loading and writing to a remote Access database - this is some distortion. Moreover, that to load easily, but the record back to Access how much understood - much more difficult. Moreover, since Excel will access a remote database, Access, it is a means to network storage, or on the FTP server. That is, the easier it will be to put in Excel file sharing online storage than on sharepoint?
    Last edited by Remphan; 02-27-2016 at 09:42 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2010 Collaboration
    By jambo2013 in forum Excel General
    Replies: 1
    Last Post: 06-22-2015, 11:12 AM
  2. Need Collaboration on a Large VBA Project?
    By LVScottT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-16-2015, 04:05 PM
  3. Survey on Collaboration and Spreadsheets
    By dklcheng in forum Excel General
    Replies: 2
    Last Post: 03-21-2014, 01:31 AM
  4. Replies: 0
    Last Post: 10-08-2013, 10:54 AM
  5. Multi user collaboration capability excel 2013 or 365
    By skearney1975 in forum Excel General
    Replies: 0
    Last Post: 05-17-2013, 10:40 AM
  6. Drawing Program Collaboration
    By Zone in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2006, 12:50 PM
  7. SUNDERA - Real Time Excel Collaboration
    By Aesaes in forum Excel General
    Replies: 0
    Last Post: 03-03-2006, 09:39 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1