Results 1 to 9 of 9
  1. #1
    4 Star Lounger
    Join Date
    Mar 2004
    Location
    Griffith, New South Wales, Australia
    Posts
    507
    Thanks
    0
    Thanked 0 Times in 0 Posts

    A way to merge two Excel files?

    Not sure if this is the place for this question, but I'll do it anyway.

    I have two users who work on a spreadsheet. They work in different locations but share the same data. So they both need a copy of the same spreadsheet and an easy way to merge the data. One of them is not always on line, either. They both need to add data, and both need to be able to see the data the other has entered (on about a daily basis). Synchronising wont work because that process looks for the most recent version of the file, and my research indicates that Excel does not have the 'merge two files' option that Word has.

    Any suggestions for how to easily merge the data in the files?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: A way to merge two Excel files?

    Have you thought about using Google Spreadsheets?
    Pro: it's free, and people can collaborate on a spreadsheet using internet.
    Con: it has fewer bells and whistles than Excel, and although you can control who can see the spreadsheet, you may not want to use this for sensitive data.

  3. #3
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,571
    Thanks
    5
    Thanked 1,056 Times in 925 Posts

    Re: A way to merge two Excel files?

    Do you have Windows Sharepoint Services running (part of Windows Server 2003)? Or Office Sharepoint Server (extensions to WSS)?

    Joe
    Joe

  4. #4
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: A way to merge two Excel files?

    Have a look at the Excel help article titled "About shared workbooks"
    <hr>
    If you need input from several people, you can create a shared workbook (shared workbook: A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users.) and place it on a network location where they can edit it simultaneously. For example, if the people in your workgroup each handle several projects and need to know each other's status, the group could use a shared workbook. All persons involved can then enter the information for their projects in one and the same workbook.
    <hr>
    I have used this in combination with Briefcase to allow someone who is offline to edit a workbook and then merge their changes back.

    StuartR

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: A way to merge two Excel files?

    Using the Share Workbook feature in Excel is asking for problems - you greatly increase the probability of corrupting the workbook.

  6. #6
    4 Star Lounger
    Join Date
    Feb 2004
    Location
    Saint Charles, Missouri, USA
    Posts
    565
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A way to merge two Excel files?

    Hans,

    In lieu of "Shared Workbook", what about putting the workbook on a known location on the network and letting people access the same workbook ? This way only ONE person can access the workbook at one time.
    Scott

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: A way to merge two Excel files?

    That is what I normally do. But Johbot mentioned that "They work in different locations", so I assume that they're not connected by a LAN.

  8. #8
    4 Star Lounger
    Join Date
    Feb 2004
    Location
    Saint Charles, Missouri, USA
    Posts
    565
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A way to merge two Excel files?

    <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>

    Thus your suggestion for Google Spreadsheets.

    A possible alternative, put the spread sheet on free interent hard drive AKA free online storage.
    Scott

  9. #9
    4 Star Lounger
    Join Date
    Mar 2004
    Location
    Griffith, New South Wales, Australia
    Posts
    507
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A way to merge two Excel files?

    Thank you Hans.

    Your suggestion is a good one and I think it will work.

    Thanks to everyone else for their suggestions. The key to the problem is that the two people are not co-located and that rules out many of the sharing options that involve servers and common file location.

Posting Permissions

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