Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 27th 08, 03:00 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
Posts: 6
Default How to stop "Locked for Editing" in Excel?

After opening my spreadsheet and performing work, I save my work and close my
spreadsheet. But, when I try to reopen the spreadsheet, I get the message,
"Locked for editing". The only way I can reopen the spreadsheet is to reboot
my computer. I've tried uninstalling my Office 2003 and re-installing the
program, but the problem comes back with the re-install. Any help will be
much appreciated. Thanks,
--
Jim

  #2   Report Post  
Old August 27th 08, 04:07 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default How to stop "Locked for Editing" in Excel?

It sounds like you have a hidden instance of excel still running.

I'd close all the visible instances of excel.
Then hit alt-ctrl-delete to open the task manager
Then look on the Processes tab to see if there are any excel.exe's still
running.

You could kill them (and lose any changes that you have made to unsaved
workbooks in that instance).

Or you could use a VBScript that could unhide those hidden instances and close
them nicely.

If you want to try the VB script technique, start notepad and copy this code
into that notepad window:

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 save this file onto your desktop as UnhideExcel.VBS (not *.txt).

Close all the visible instances of excel and double click this script file on
your desktop.

If you see a newly visible instance of excel, then close it and double click on
the vbs file again (until you get the "excel is not running" message.

========
Any chance you have a macro (in MSWord, Excel, Powerpoint, Outlook, or even
script) that opens excel with its windows hidden.

Jim Murray wrote:

After opening my spreadsheet and performing work, I save my work and close my
spreadsheet. But, when I try to reopen the spreadsheet, I get the message,
"Locked for editing". The only way I can reopen the spreadsheet is to reboot
my computer. I've tried uninstalling my Office 2003 and re-installing the
program, but the problem comes back with the re-install. Any help will be
much appreciated. Thanks,
--
Jim


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to unlock a file that is "locked for editing" Catherine Excel Discussion (Misc queries) 4 September 21st 15 08:39 AM
Shared Workbook is "locked for editing" susu Excel Worksheet Functions 0 April 17th 08 04:38 PM
"Locked for Editing" error on a non-protected file Jim Murray Excel Discussion (Misc queries) 1 March 8th 08 12:42 PM
"Locked for Editing" problem in Excel 2007 Adam Excel Discussion (Misc queries) 1 August 22nd 07 03:29 AM
How to open a "locked for editing" spreadsheet to unlock it? metmart Excel Discussion (Misc queries) 1 April 26th 06 05:55 PM


All times are GMT +1. The time now is 04:54 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017