Free Microsoft Excel 2013 Quick Reference

My excel file is locked for editing. How do I get it opened.

While working on an excel worksheet, somehow the file went away. When I
tried to open it again, I got a message box "File in Use" with a message that
the file is locked for editing. Can't open it. Help if you can. Thanks
David


Post your answer or comment

comments powered by Disqus
While working on an excel worksheet, somehow the file went away. When I
tried to open it again, I got a message box "File in Use" with a message that
the file is locked for editing. Can't open it. Help if you can. Thanks
David

Some keys on my keyboard is locked in Exel. How do I unlock it?

I have Excel 2000. I am using Windows 7. I have been recording my golf scores for 14 weeks with only 2 weeks to go and now my spreadsheet will not open. I get 2 messages. The first is a box titled file in use with the message that the file, Summary for 2011, is locked for editing.by Karen. Click Notify to open a read-only copy of the document and receive notification when the document is no longer in use.” It is not in use that I can tell. How did it get locked and how do I unlock it? My second message when I click one of the choices is Microsoft Excel has stopped working. A problem caused the program to stop working and will have to shut down. I have been able to open a similar file, Summary for 2010. and my golf roster without a problem. Unfortunately I made the mistake of not backing up this file

Hello,
I have a macro-based tool that I posted on my company's file library. The tool's settings are set such that they can only be viewed if the user doesn't select "save as" from the website, but only "open". (This forces them to get it from the website each time so that they have the newest version always).

Some of the users have been telling me that they get an error message that the file is locked for editing by them and therefore they cannot work with the tool. I open it the same way and do not get that message. Does anyone know what setting or issue could be causing this?
-Ilya

Hi, everyone. This is a bit of an odd request, but here goes. Is there a way to suppress the 'file is locked for editing' message that is displayed when a file is in use when you first open a workbook? I'm not opening another workbook from inside a macro, I'm talking about from not having Excel open then opening a file and having the file 'catch itself' and suppress the message and open in read only mode anyway. In the end, if the file is available, I want the user to use/edit it, but if someone else has it open, I want it to open in read-only mode without the user seeing the message. I will fire a macro on workbook_close to save the file as something else. Shared workbooks is not an option here.

Thanks for any help.

Since my upgrade to Office 2003, my Excel files are "locked for editing."
Some of them were files created in Excel 2000, a couple of others were closed
by the computer restart when MS's automatic updates processed and the files
were open. Is there some way to stop this?

I had 2 files with the same name in excel. After I excited excel, I wanted to
rename my new file, and I thought I was renaming the new file, but I actually
renamed the old file I was working in and when it said this file exists do
you want to change I said yes. I lost all my work. How do I get it back?

what is compatibility mode and how do you get it off? it wont let me type in
the cells.

in vba for access how do i get the day of the week for a date field?

I altered a file that I got from someone else. There is no one else using my
computer (a laptop). I saved and closed the file (the file MIGHT have been
closed with an unplanned shutdown). Now I cannot open the file for editing
because it says it is locked by ME. How do I either open it or delete it?
thank you.

I'm trying to open an Excel file on a network drive. However when I try to
open it. It has an Error Message:
File in use. Drivers return 'Taco far return disk Chart 2005.xls' is locked
for editing. Options are 'Read Only', 'Notify' or 'Cancel'

I know no one is in the spreadsheet, and does not indicate who would be if
there was. Can anyone help?

Since my upgrade to Office 2003, my Excel files are "locked for editing."
Some of them were files created in Excel 2000, a couple of others were closed
by the computer restart when MS's automatic updates processed and the files
were open. Is there some way to stop this?

We have a spreadsheet on a network folder than whenever it is opened, we get
message "File In Use. is locked for editing by " with
the read-only and Notify buttons. Problem is, the specified user does NOT
have the file open. We've made sure no one has the file open, we had that
particular user reboot his system and not attempt to open the file again.
Even when this particular user DOES open the file, even he also still gets
the same message. We cannot seem to find a way to unlock the file for editing
now. I can copy the file to my local drive and open it no problem locally,
but I cannot move that local copy back to the network folder and attempt to
overwrite the original version, I get a sharing violation error that the
source or destination file may be in use (but neiter are as far as we can
tell). Any suggestions? Thnx in advance.

Jim

hi there,

I can't seem to figure this out but it would seem like easy.
I am trying to enable my personal file because i have recorded a few macros in there. Somehow, when i open a blank excel file my personal file is no longer there. How do i get to open up/enable whenever i open an excel file?

thanks for your help.

austin

"more fill colors" used to show up for me in excel when i filled in colors on
a worksheet. i would then be able to customize the fill color. however, i
bought a new compture with windows xp loaded, and now that option does not
appear in my excel (but does appear in word). how do it get it in excel?

"more fill colors" used to show up for me in excel when i filled in colors on
a worksheet. i would then be able to customize the fill color. however, i
bought a new compture with windows xp loaded, and now that option does not
appear in my excel (but does appear in word). how do it get it in excel?

In our timesheet, we enter start time and end time. How do I get Excel to
return # of hrs. worked? If is use: (d11-c11) a decimal fraction is returned.
ie. .21 for 8:00 am to 1m. How do I get it to return 5 hrs.?

Thanks

I lost my contact information, in an Excel spreadsheet that is being used for
a mail merge program. How do I get that information back? I am using Excel
2003. All of the rest of the information is intact, such as company names,
phone numbers, and addresses. But I would like to get the personal names
back for contact. Is this possible?

i recently installed the solver add-in, but when i got to use the solver it
says "Solver32.dll is unavailable-you will be able to define and edit solver
models, but not actually solve them. To fix this, please use Excel Setup to
reinstall solver"
how do i reinstall it? or get it to work?

I would like to have Excel setup so I can enter a number into F3 that would
be added
to a total in B3...then have the number that was enetered in F3 deleted,
thus leaving
F3 blank and ready for a new entry.

Is this possible and how do I set it up?

In our timesheet, we enter start time and end time. How do I get Excel to
return # of hrs. worked? If is use: (d11-c11) a decimal fraction is returned.
ie. .21 for 8:00 am to 1:pm. How do I get it to return 5 hrs.?

Thanks

Hey all. Just got Excel 2003, and have a real basic question.

I'm working in large files with very long cells, and everytime i click into
one to edit it, it expands to take up almost the entire screen. Problem is, i
need to look at cells in other columns, and this is a huge pain. How do i get
it to stop?

Thanks in advance!

One day I opened up excel and it had all these marks for formating in my
form. This also happened in word. How do I get rid of them?

In previous versions of Microsoft Office you could have the name of the
current file and it's full path appear at the top of the screen. Now, with
Office 2007 all I can get is the file name. How do I get it to show the full
path?


No luck finding an answer? You could always try Google.