I have one excel workbook called the master battleboard. I also have copies of this on other sites. My aim is to merge them so the master has everyones info. I know no ones info will be overwritten as they all have different sections to write in. The problem is that in order to merge I need to share the workbook first. When I go to "Tools" - "Share Workbook" and the click allow changes by more than one person and OK, it asks if it is OK to save when I click OK Excel crashes and brings up and application error : Access Violation (0xc0000005) address 0x00560055. I am using Excel 97 on a windows NT4 sp6 workstation. Does anyone know how I can solve this problem? It is the only thing stopping me from completing my task.
Thank you in Advance!
Maria
Thank you in Advance!
Maria