Sharing a workbook

mbunce · Mar 20th, 2002, 03:22 AM

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

Tom Schreiner · Mar 20th, 2002, 04:14 AM

I sure hope that this is not the best answer you get.

I had a similiar problem on WINNT 4 and it about drove me mad. I drove the help desk mad. No one could help me so I tried everything I could think of and then some.

If all else fails, and I'm hoping it does not, here is what worked for me. Don't ask why because I do not know. But it worked.

I opened a new workbook alongside the one generating the protection faults in WINNT.

I copied, not moved, each individual worksheet from the old workbook to the new one, renamed the new workbook, and never had a problem again...

Is there a chance that your workbook was created on another machine? With a diferent
operating system?

I may have just been lucky, but we are still using it from over a year ago!!!

Good Luck!

Jack in the UK · Mar 20th, 2002, 03:22 PM

Hi Maria --

NT4 sp6 ok up todate, try the copy over trick, not cut and paste thou.. resave new name or name original old before transfer,

Are the Excel versions and build compatable??? Try on other PC's

Somethings simple is bugging Excel and shes comfused, what alterations have you nmade sine was all ok?

Mar 20th, 2002, 03:22 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi Maria -- NT4 sp6 ok up todate, try the copy over trick, not cut and paste thou.. resave new name or name original old before transfer, Are the Excel versions and build compatable??? Try on other PC's Somethings simple is bugging Excel and shes comfused, what alterations have you nmade sine was all ok? __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 03:22 AM	#1
mbunce New Member Join Date: Mar 2002 Location: Huddersfield, UK Posts: 1	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

Mar 20th, 2002, 04:14 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	I sure hope that this is not the best answer you get. I had a similiar problem on WINNT 4 and it about drove me mad. I drove the help desk mad. No one could help me so I tried everything I could think of and then some. If all else fails, and I'm hoping it does not, here is what worked for me. Don't ask why because I do not know. But it worked. I opened a new workbook alongside the one generating the protection faults in WINNT. I copied, not moved, each individual worksheet from the old workbook to the new one, renamed the new workbook, and never had a problem again... Is there a chance that your workbook was created on another machine? With a diferent operating system? I may have just been lucky, but we are still using it from over a year ago!!! Good Luck!