Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Dec 2009
    Location
    Poole, UK
    Posts
    95
    Thanks
    22
    Thanked 2 Times in 2 Posts

    Sharing a spreadsheet on a local area network?

    I wonder if anyone on this forum has any experience of shared working of a spreadsheet on a network.

    A small charity that I support has all it's membership data on a fairly complex 10MB Excel spreadsheet (they use Excel 2003). The spreadsheet uses macros, conditional formatting etc etc and works really well for what they need.

    However, they now need to expand and wonder if the spreadsheet can be shared via the office LAN so that one, or possibly two, more people can access the database - preferably not just in a read-only mode (ie so all 2, or 3, could update and modify the data).

    Can anyone please help me to find a way to do this? Is a later version of Excel needed or would one need to use a totally different spreadsheet (eg Google sheets)? If the latter, will one lose some of the existing functionality etc.

    I guess this is a 'classic' problem so hope someone will have some experience of how to best deal with it.

    Many thanks.

  2. #2
    WS Lounge VIP mrjimphelps's Avatar
    Join Date
    Dec 2009
    Location
    USA
    Posts
    3,407
    Thanks
    447
    Thanked 405 Times in 377 Posts
    Go into Excel help and search on "Share Workbook". Everything you need to know will be explained very clearly.

    This sort of thing has been happening since way before Excel 2003, so I'm sure you will have no trouble doing this.

  3. #3
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 986 Times in 916 Posts
    Sharing can lead to corruption issues so be sure to back it up daily.
    It's also worth checking the list of people using the workbook regularly to ensure there are no phantom users.

    cheers, Paul

Tags for this Thread

Posting Permissions

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