Excel problems

Clarifications

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".

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.

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.

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

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.

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.

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

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

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.

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

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.

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.

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....