Sharing a workbook
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Sharing a workbook

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Huddersfield, UK
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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


  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com