locked for editing

[R.VENKATARAMAN]

due to some mistake of mine occasionally the excel file gets locked for
editing and I am not able to save etc. I have to save it in different name
and then reboot computer and delete old file and rename the new file to old
file . I am not able to trace what mistake I do. can anybody suggest
possible mistakes.

 

[Guest]

I am from the MS Excel support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consultin

 

[Mark E. Philpot]

If you "Protect" a range of cells or a workbook, access is
denied. On the toolbar Tools > Protection >

There are options to choose from.

with regards mark E. Philpot

 

[Dave Peterson]

maybe some suggestions from Debra Dalgleish's site:

http://www.contextures.com/xlfaqApp.html#ReadOnly
http://www.contextures.com/xlfaqApp.html#AlreadyOpen

When you open a file in excel, excel creates some files in your windows temp
folder.

If excel crashes, then these files don't get cleaned up. You can clean them up
yourself.

Windows start button|run
%temp%

and clean up all you want. (I delete everything--just don't be in the middle of
an install!)

And sometimes excel leaves a hidden instance running. Some versions of Windows
(NT/2k) will allow you to kill those processes.

If excel looks like it's not running:

Alt-ctrl-delete
Task manager
Processes
look for excel.exe and kill it.
(serves the same purpose as rebooting and it's a lot quicker).

Win98 doesn't have this kind of option. I have a .vbs file on my desktop that
tries to unhide any hidden excel processes.

I close all the excel programs I can see and run this until I don't see any
more:

Copy this to notepad and save it as: UnHideXL.VBS

====================

dim myXL
On Error Resume Next
Set myXL = GetObject(, "Excel.Application")
If Err.Number = 429 Then
msgbox "excel is not running"
else
myxl.visible = true
end If
On Error GoTo 0
Set myxl = nothing

=====================

Then just run this script to clean things up.

 

[R.VENKATARAMAN]

Mr. Phipot no the range of cells is not protected. my excel is excel2000
Besides it does not get locked up whil opening the file wth windows explorer
or thorugh mycomputer or recent documents. It gets locked up while
operating the file and saving.
the propertis of the file als shows only archives and NOT readonly.
of course this problem occurs only occasionally.