Questions

Excel problems

+
0 Votes
Locked

Excel problems

frostbit_ak
I have a user on my domain that keeps having this problem with Excel. She opens a workbook from a shortcut and excel will hang and go unresponsive. It is only one specific file. No one else has this issue. I can log on with my credentials and it opens fine for me on her system. I have deleted her profile off the computer and rebuilt it. This worked for about two months and then back to the same problem. It hangs, she gets the "program is not responding end now" window and Excel is done trying to open that file.
Got any suggestions?
  • +
    0 Votes
    Absolutely

    Sorry, I just have no idea why that would happen, unless she likes you and is just intentionally locking the file as an excuse to call you for "technical support".

    +
    0 Votes

    Nah

    frostbit_ak

    I don't think she would know how to make her system act like this.

    +
    0 Votes
    LocoLobo

    Have you had her log into her system then tried launching the shortcut yourself to see what is happening? I don't have any idea what it could be either, just grasping at straws.

    +
    0 Votes

    Yes

    frostbit_ak

    I have had her log on to her system and then I have tried to open the shortcut, then I had her log on to a different system and the shortcut opens. I have copied her desktop folder to a different system and the same shortcut was used successfully to open the file.

    +
    0 Votes
    ThumbsUp2

    When this issue starts happening, have her start Excel first, close the new workbook, then do file/open and navigate to where the file in question is located. See if it will open that way. If it does, the shortcut has become corrupt, possibly even trying to open the file with certain flags set or from a share/domain location that wasn't closed properly.

    +
    0 Votes
    frostbit_ak

    Once this happens the file does not open under her profile from this system at all. I have tried opening excel first and navigating to the file to open it and it does the same thing, just sits like it is opening and then program not responding.

    +
    0 Votes
    Absolutely

    save to a different location and/or different filename.

    +
    0 Votes
    frostbit_ak

    Still having the same problem. Looks like its opening, but just hangs.

    +
    0 Votes
    Absolutely

    More info, faster solution.

    +
    0 Votes
    frostbit_ak

    We have renamed it and made a new shortcut. I can?t move the file because it is on a file server and there are other users who need to work with this file as well. I have checked and it is not locking up because someone else is in the file.

    +
    0 Votes
    ThumbsUp2

    Well, that could be it right there. If the file is on a server and the only person who can't access the file, no matter where she logs in from (other computers, same login name), then it's in the server setting somewhere. Check the server's user accounts. Did she log in from another computer, connect to the server and leave the account open, then log in somewhere else? Is her account on the server set with correct permissions to access that file?

    Just a few things to check.

    +
    0 Votes
    Absolutely

    Check the user's group membership on the server where the file is located.

    +
    0 Votes
    ThumbsUp2

    So I can catch up with absolutely, and tigger too! :)

    +
    0 Votes
    frostbit_ak

    She can access this from a diffrent PC under her login and it works fine it is just the one PC that she normally works at that is having the problem. I deleted her profile from the PC and rebuilt it and it worked fine for a few months, then started locking again. It's not a membership or a rights issue or she wouldn't have ever been able to access it.

    +
    0 Votes
    LocoLobo

    Just a thought. Could it be the HW itself? My work place has some older PCs that "act up" when using excel sometimes. But it's not one person/one file it seems to be more random.

    +
    0 Votes
    frostbit_ak

    I uninstalled small business all together and reistalled it. Word, Excel, Outlook...and the same problem happend. I have deleted her profile off the pc and rebuilt it and it worked for a few months and then went back to this.

    +
    0 Votes
    Tig2

    Try deleting the shortcut. Reboot the pc. Now filesurf out to the workbook location. Open the workbook. What happens?

    If the workbook opens, create a new shortcut. If it doesn't, there is something going on between the pc and the file.

    Grasping here, just tossing out ideas.

    +
    0 Votes
    frostbit_ak

    We deleted the shortcut but no dice. The file still makes excel hang up and then stop responding. I had someone else try and it is still opening with no problem.

    +
    0 Votes
    LocoLobo

    Compared to the other peoples profiles that work? Does she use some software installed on that pc only?

    +
    0 Votes
    frostbit_ak

    She does'nt use anything diffrent. No settings or anything mapped diffrently

    +
    0 Votes
    LocoLobo

    This is going to sound crazy. I'm still wondering if this isn't a hardware issue. What if you switched her pc with another user? Then if she still has the problem you know it isn't that particular system. If the other user develops the problem then there is something in that particular pc system. Sorry, obviously grasping at straws.

    +
    0 Votes
    frostbit_ak

    I can log on to that system and the file will open for me. I created a temporary account with the same rights and permissions as her and you can open it using that account, all on the same system.
    Don't be sorry, I've gone past grasping at straws to pulling hair.

    +
    0 Votes
    ThumbsUp2

    There's an article at MS that says if you try to open a file that's on a mapped drive and the program hangs, check all mapped drives. If one is not responding or temorarily disconnected, the application will hang.

    http://support.microsoft.com/kb/313937/en-us

    WORKAROUND
    To work around this behavior, use one of the following methods.

    Method 1: Do not use persistent connections
    When you connect a mapped drive, click to clear the Reconnect at logon check box. By clearing this check box, the mapped drive will not be connected the next time that you log on to the computer. See the "More Information" section for more information about how to map a network drive.

    Method 2: Use a user logon script
    If you can, use a logon script to connect a user to the appropriate servers every time that the user logs on. Make sure that the script maps the drive in a non persistent state. If the drive is not available as the logon script runs, the drive is not mapped. This behavior prevents the issue.

    Method 3: Use server mirroring
    If the connection is over a Wide Area Network (WAN), consider implementing server mirroring. Server mirroring duplicates a distant server locally. Then, map your drive to the local, duplicate server. Doing this can reduce the wait time by connecting to a local server.

    Method 4: Use a shortcut to the network location
    Use a shortcut on the Microsoft Windows desktop or in My Network Places to connect to the network location that you want.

    +
    0 Votes
    frostbit_ak

    We have user login scripts the run everytime they login. The way our scrips are set up, when a user logs on the script first deletes the drive and then remaps the drive.

    +
    0 Votes
    LocoLobo

    like

    \\server1\docs\excel\test.xls

    +
    0 Votes
    frostbit_ak

    I am really starting to think there has to be a problem with the file itself and not her profile, or the shortcuts she is working with. I just don't understand why it is only that one user that is having the issue....

    +
    0 Votes
    LocoLobo

    This is really bizarre. I can't think of anything else either.

    +
    0 Votes
    ThumbsUp2

    Move the file to a different location on the server, test it, then try moving that file to her computer and open it directly, test it, then create a shortcut to the file on her computer, test it.....

    Test all ways possible to open that one file.

  • +
    0 Votes
    Absolutely

    Sorry, I just have no idea why that would happen, unless she likes you and is just intentionally locking the file as an excuse to call you for "technical support".

    +
    0 Votes

    Nah

    frostbit_ak

    I don't think she would know how to make her system act like this.

    +
    0 Votes
    LocoLobo

    Have you had her log into her system then tried launching the shortcut yourself to see what is happening? I don't have any idea what it could be either, just grasping at straws.

    +
    0 Votes

    Yes

    frostbit_ak

    I have had her log on to her system and then I have tried to open the shortcut, then I had her log on to a different system and the shortcut opens. I have copied her desktop folder to a different system and the same shortcut was used successfully to open the file.

    +
    0 Votes
    ThumbsUp2

    When this issue starts happening, have her start Excel first, close the new workbook, then do file/open and navigate to where the file in question is located. See if it will open that way. If it does, the shortcut has become corrupt, possibly even trying to open the file with certain flags set or from a share/domain location that wasn't closed properly.

    +
    0 Votes
    frostbit_ak

    Once this happens the file does not open under her profile from this system at all. I have tried opening excel first and navigating to the file to open it and it does the same thing, just sits like it is opening and then program not responding.

    +
    0 Votes
    Absolutely

    save to a different location and/or different filename.

    +
    0 Votes
    frostbit_ak

    Still having the same problem. Looks like its opening, but just hangs.

    +
    0 Votes
    Absolutely

    More info, faster solution.

    +
    0 Votes
    frostbit_ak

    We have renamed it and made a new shortcut. I can?t move the file because it is on a file server and there are other users who need to work with this file as well. I have checked and it is not locking up because someone else is in the file.

    +
    0 Votes
    ThumbsUp2

    Well, that could be it right there. If the file is on a server and the only person who can't access the file, no matter where she logs in from (other computers, same login name), then it's in the server setting somewhere. Check the server's user accounts. Did she log in from another computer, connect to the server and leave the account open, then log in somewhere else? Is her account on the server set with correct permissions to access that file?

    Just a few things to check.

    +
    0 Votes
    Absolutely

    Check the user's group membership on the server where the file is located.

    +
    0 Votes
    ThumbsUp2

    So I can catch up with absolutely, and tigger too! :)

    +
    0 Votes
    frostbit_ak

    She can access this from a diffrent PC under her login and it works fine it is just the one PC that she normally works at that is having the problem. I deleted her profile from the PC and rebuilt it and it worked fine for a few months, then started locking again. It's not a membership or a rights issue or she wouldn't have ever been able to access it.

    +
    0 Votes
    LocoLobo

    Just a thought. Could it be the HW itself? My work place has some older PCs that "act up" when using excel sometimes. But it's not one person/one file it seems to be more random.

    +
    0 Votes
    frostbit_ak

    I uninstalled small business all together and reistalled it. Word, Excel, Outlook...and the same problem happend. I have deleted her profile off the pc and rebuilt it and it worked for a few months and then went back to this.

    +
    0 Votes
    Tig2

    Try deleting the shortcut. Reboot the pc. Now filesurf out to the workbook location. Open the workbook. What happens?

    If the workbook opens, create a new shortcut. If it doesn't, there is something going on between the pc and the file.

    Grasping here, just tossing out ideas.

    +
    0 Votes
    frostbit_ak

    We deleted the shortcut but no dice. The file still makes excel hang up and then stop responding. I had someone else try and it is still opening with no problem.

    +
    0 Votes
    LocoLobo

    Compared to the other peoples profiles that work? Does she use some software installed on that pc only?

    +
    0 Votes
    frostbit_ak

    She does'nt use anything diffrent. No settings or anything mapped diffrently

    +
    0 Votes
    LocoLobo

    This is going to sound crazy. I'm still wondering if this isn't a hardware issue. What if you switched her pc with another user? Then if she still has the problem you know it isn't that particular system. If the other user develops the problem then there is something in that particular pc system. Sorry, obviously grasping at straws.

    +
    0 Votes
    frostbit_ak

    I can log on to that system and the file will open for me. I created a temporary account with the same rights and permissions as her and you can open it using that account, all on the same system.
    Don't be sorry, I've gone past grasping at straws to pulling hair.

    +
    0 Votes
    ThumbsUp2

    There's an article at MS that says if you try to open a file that's on a mapped drive and the program hangs, check all mapped drives. If one is not responding or temorarily disconnected, the application will hang.

    http://support.microsoft.com/kb/313937/en-us

    WORKAROUND
    To work around this behavior, use one of the following methods.

    Method 1: Do not use persistent connections
    When you connect a mapped drive, click to clear the Reconnect at logon check box. By clearing this check box, the mapped drive will not be connected the next time that you log on to the computer. See the "More Information" section for more information about how to map a network drive.

    Method 2: Use a user logon script
    If you can, use a logon script to connect a user to the appropriate servers every time that the user logs on. Make sure that the script maps the drive in a non persistent state. If the drive is not available as the logon script runs, the drive is not mapped. This behavior prevents the issue.

    Method 3: Use server mirroring
    If the connection is over a Wide Area Network (WAN), consider implementing server mirroring. Server mirroring duplicates a distant server locally. Then, map your drive to the local, duplicate server. Doing this can reduce the wait time by connecting to a local server.

    Method 4: Use a shortcut to the network location
    Use a shortcut on the Microsoft Windows desktop or in My Network Places to connect to the network location that you want.

    +
    0 Votes
    frostbit_ak

    We have user login scripts the run everytime they login. The way our scrips are set up, when a user logs on the script first deletes the drive and then remaps the drive.

    +
    0 Votes
    LocoLobo

    like

    \\server1\docs\excel\test.xls

    +
    0 Votes
    frostbit_ak

    I am really starting to think there has to be a problem with the file itself and not her profile, or the shortcuts she is working with. I just don't understand why it is only that one user that is having the issue....

    +
    0 Votes
    LocoLobo

    This is really bizarre. I can't think of anything else either.

    +
    0 Votes
    ThumbsUp2

    Move the file to a different location on the server, test it, then try moving that file to her computer and open it directly, test it, then create a shortcut to the file on her computer, test it.....

    Test all ways possible to open that one file.