Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Essex, England
    Posts
    175
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Workbook Printer Driver Dependency (2000 SR1)

    I have a User with a series of Shared Workbooks all based on the same template, supplied by another office, (Excel 2000 SR1 running on Windows 2000 SP2). They're all updated at various times and, despite the frequently repeated entreaties against sharing workbooks, they all work sweetly except for two sheets. All other Users can open these two sheets without problems. When my User tries, however, the status bar at the bottom of the screen grows to 100% and then stops. The hourglass remains and, when looking at Task Manager, CPU resources are locked at 100%, with Excel.exe using between 95% to 98%. The only way to resolve this is to force the Excel application to close from Task Manager.

    His default printer is an HP LaserJet 8150. He has two other printer objects available to him: a HP 4 Plus and a colour LaserJet 4600. If he chooses either of these two as his default printer, one of the problematical files opens but the other still fails. I've examined the workbooks, (they open fine on my box), and can find no external references, no formulae other than the SUM() of values on the same sheet. The User has no add-ins that don't also feature on his colleagues' machines etc. etc. The sheets contain no exotic fonts or formating that I can see.

    I can salvage the file by copying the contents to a new workbook to enable him to use it, but he tells me that this has happened before on other files in the same folder and I'd like to find and treat the root cause rather than rescuing him every time it happens.

    Does anyone have any ideas about what's going on?

    Thanks, in advance.
    Regards,

    Steve

    "A good friend will help you move; a really good friend will help you move a body"

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Workbook Printer Driver Dependency (2000 SR1)

    Check out the things in Jan Karel <!profile=Pieterse>Pieterse<!/profile>'s Starred <post#=290455>post 290455</post#> to see if any of those suggestions help.

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Essex, England
    Posts
    175
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Workbook Printer Driver Dependency (2000 SR1)

    Thanks for the reply, Steve, but I'd already looked here, (perhaps I should have mentioned it first). I tried all of the tests I felt relevant but the strange this is that the problem isn't with Excel per se, but with Excel and these two particular workbooks on this one User's PC. Other workbooks open fine and Excel exhibits no strange behaviour when any other workbooks are loaded.

    It just occurred to me that I haven't asked this User to try opening the files when logged in to another PC. I'll try that and report back the results.

    Any more suggestions...?
    Regards,

    Steve

    "A good friend will help you move; a really good friend will help you move a body"

  4. #4
    Lounger
    Join Date
    Feb 2001
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workbook Printer Driver Dependency (2000 SR1)

    Steve, I am having the same issue. It is not a problem opening up other excel spreadsheets, just a particular workbook with a particular user. Other users are able to access the workbook fine. I did find that when I went into the workbook share (Tools/SharedWorkbook/Editing Tab), there seemed to be a "lock" by this user each time she tried to access it (over 15 times). I deleted the user from the list. The next time she tried to access the file again, the same thing happened. The spreadsheet appears to open, but the hourglass remains and she does not gain access to the file. Have you found anything else?

    Thanks in advance,

    Linda

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Essex, England
    Posts
    175
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Workbook Printer Driver Dependency (2000 SR1)

    Linda,

    I looked where you suggested and there were multiple entries for the User in question. These were deleted but when he tried to open the file next time, Excel crashed completely with an error message that said: "Excel has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created".

    I looked in Event Viewer to see the log, (I'm assuming that's where it was created - I couldn't find anything else) and found an entry as follows:
    Event Source: Dr Watson
    Event ID: 4097
    The application, , generated an application error The error occurred on 04/06/2004 @ 14:36:40.972 The exception generated was c0000008 at address 77F91B0C (KiRaiseUserExceptionDispatcher)

    followed by a binary dump lasting pages.

    Looking on EventID.Net, (a very useful resource), I found a lot of information about this particular event, but all catregorised by the nature of the application reported as generating the error. In this case, that application doesn't have a name!

    The only references to KiRaiseUserExceptionDispatcher I could find were on fairly techy programming sites and don't appear to apply to Excel and, frankly, don't mean anything to me.

    I asked the User to log on to another PC to try to open the files and the problem appears to follow him around.

    Can anyone suggest what to look at next...?
    Regards,

    Steve

    "A good friend will help you move; a really good friend will help you move a body"

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Workbook Printer Driver Dependency (2000 SR1)

    I assume then that someone else can log onto this peron's computer as themselves and get it to work?

    The issue then is what restrictions or problem this particular user has and it is not stored on his computer but on the network somewhere. Perhaps creating a new user id for him on the network might "fix the problem"

    Steve

  7. #7
    Lounger
    Join Date
    Feb 2001
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workbook Printer Driver Dependency (2000 SR1)

    Steve,
    When I deleted the multiple entries, from the workbook share, I did not receive the error log. I had the same symptons as before. In my case, I am able to sign on as a different user and use the appropriate file from that machine. How about you? Did you create a new user as was suggested in a later post? Did that work? Unfortuantely, creating a new user profile in my environment would require contacting additional people and inconveniencing the user, so I'd like to be sure before I start that process.

    Linda

  8. #8
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Essex, England
    Posts
    175
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Workbook Printer Driver Dependency (2000 SR1)

    I've had to pass the problem "upstairs" for some more specialised minds to look at, (we're on strict limitations as to how much time it's "economic" to spend trying to resolve each problem as it arises, rather than doing detailed research ourselves <img src=/S/frown.gif border=0 alt=frown width=15 height=15>. The emphasis is on turnover, which I personally find doesn't really benefit the User in these cases and makes the support task a great deal less interesting).

    I'm in the same situation as Linda in that, it takes involvement of several people in various different IT departments and locations to create a new User ID for someone and the perceived overhead is seen as too much to resolve a problem that exists on such a tiny proportion of the User's files.

    I must admin that I made the assumption that if the problem follows the User from machine A to machine B, and the normal User of machine B has no problems with the same files (after User A has logged off again), then User B would have no problem with the files on User A's machine. If the call gets transferred back to me, (asuming someone upstairs has an original suggestion worth trying), then I'll prove that case explicitly.

    Thanks for your input.
    Regards,

    Steve

    "A good friend will help you move; a really good friend will help you move a body"

Posting Permissions

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