Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
locked file
This isnt really an excel question but I thought Id try on here just in case
anyones come across this before. In short I have a networked xls file which the server thinks is open and therefore the users can do nothing with it apart from use it as read only. The file is not open but I cant do anything with this file in terms of delete, overwrite etc. Anyone know any fancy ways (apart from rebooting the server) how to solve this problem? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
locked file
Excel stores in Windows\Temp(win98) folder a copy(s) of any file that is open.
Sometimes this *.tmp file is not deleted from the Temp folder when you close out Excel(maybe a crash of Excel?) or the file, so Excel thinks it is still open and in use. You can try a re-boot and see if that clears it up. If not, after a re-boot, clear out your Windows\Temp folder. If using WinXP your Temp folder would be under user....... Documents and Settings\User\Local Settings\Temp If on a network, re-booting the server may be the only solution other than copying the data to a new workbook. Gord Dibben Excel MVP On Mon, 18 Sep 2006 03:04:01 -0700, Reggiee wrote: This isnt really an excel question but I thought Id try on here just in case anyones come across this before. In short I have a networked xls file which the server thinks is open and therefore the users can do nothing with it apart from use it as read only. The file is not open but I cant do anything with this file in terms of delete, overwrite etc. Anyone know any fancy ways (apart from rebooting the server) how to solve this problem? Thanks Gord Dibben MS Excel MVP |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
locked file
Thanks Gord
It was on the network which is what has been causing the issues but other points duly noted and appreciated Reggiee "Gord Dibben" wrote: Excel stores in Windows\Temp(win98) folder a copy(s) of any file that is open. Sometimes this *.tmp file is not deleted from the Temp folder when you close out Excel(maybe a crash of Excel?) or the file, so Excel thinks it is still open and in use. You can try a re-boot and see if that clears it up. If not, after a re-boot, clear out your Windows\Temp folder. If using WinXP your Temp folder would be under user....... Documents and Settings\User\Local Settings\Temp If on a network, re-booting the server may be the only solution other than copying the data to a new workbook. Gord Dibben Excel MVP On Mon, 18 Sep 2006 03:04:01 -0700, Reggiee wrote: This isnt really an excel question but I thought Id try on here just in case anyones come across this before. In short I have a networked xls file which the server thinks is open and therefore the users can do nothing with it apart from use it as read only. The file is not open but I cant do anything with this file in terms of delete, overwrite etc. Anyone know any fancy ways (apart from rebooting the server) how to solve this problem? Thanks Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
file will not open | Excel Discussion (Misc queries) | |||
file is locked does not appear in Excel if file already open by an | New Users to Excel | |||
Filling Text from Another File | Excel Worksheet Functions | |||
How do I unlock FILE access? | Excel Discussion (Misc queries) | |||
Locked out of default file location | Excel Discussion (Misc queries) |