Hi everyone.
A user can´t edit a excel file. It says that the same user has the file open already, so he can only open it in read only.
WIndows 2000pro
Office 2000
Hi
The most likely reason for this is that your user has excel opened twice ie two instances of the application are open on the machine and they do actually already have the file open.
Check the task bar for multiple instances failing that check on task manager.
Another late thought is that if you 'hot desk' in your workplace the user has the file open on another pc!?
;-) If a man says something and there are no women there to hear him, is he still wrong?
Thanks for the respons.
Yes, we got "hot desk" or "multipel loggon".
Perhaps I explande my question poorly.
Is theire any way to "disconnent" his first session with the file, so he can open the file at his current location?
I´v checked, and his not logg in on any other computer.
Check to see that your user doesn't have excel opened twice on the machine he is using now.
This, as I said, is the most likely reason for the problem. Unfortunately if that isn't the solution I'm a bit stuck. He obviously has the file open somewhere and without identifying where I can't think of a way to shut the file down without having him kicked off the network completely to close all his work down!
;-) If a man says something and there are no women there to hear him, is he still wrong?
Have you tried workbook sharing?
Tools > Share workbook > check the box "Allow changes..."
Be aware that some functions like macro editing, protecting, etc.. do not work any more
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.