 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / April 2005excel locked by another user=myself
this is for excel 2000 excel crashed while doing some vba code testing now when re-opening the sheet where crash occurred i get the file is already open by myself, read-only, notify msg is there some way to reset the file lock pointers/file in use/etc without rebooting? took a quick look in registry but nothing jumped out at me Find your Temp Directories -- c:\windows\temp c:\Documents and Settings\<user>\Local Settings\Temp Delete all files & folders in those directories Restart Excel Open file You may need to reboot if you still cant get in if all files could not be deleted : this is for excel 2000 : excel crashed while doing some vba code testing [quoted text clipped - 4 lines] : rebooting? : took a quick look in registry but nothing jumped out at me thanks for the reply, its kind of daunting in the Documents and> Settings\<user>\Local Settings\Temp area with so much in there, with other apps open, i'm afraid of botching up some other open app will shut down all apps before next reboot, then delete everything there and then after reboot and open excel and see what shows up > Find your Temp Directories -- c:\windows\temp c:\Documents and > Settings\<user>\Local Settings\Temp [quoted text clipped - 13 lines] > : rebooting? > : took a quick look in registry but nothing jumped out at me Unless you are in the habit of installing programs to run from TEMP, you will be fine deleting it all. You can always move it to the recycle bin for a couple of days if you want before totally deleting : thanks for the reply, its kind of daunting in the : Documents and> Settings\<user>\Local Settings\Temp [quoted text clipped - 23 lines] : > : rebooting? : > : took a quick look in registry but nothing jumped out at me |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.