Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 26th 06, 04:14 PM posted to microsoft.public.excel.misc
metmart
 
Posts: n/a
Default How to open a "locked for editing" spreadsheet to unlock it?

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?

  #2   Report Post  
Old April 26th 06, 05:55 PM posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default How to open a "locked for editing" spreadsheet to unlock it?

Most common cause.............

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 locked for editing.

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.


Gord Dibben Excel MVP




On Wed, 26 Apr 2006 08:14:01 -0700, metmart
wrote:

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?


Gord Dibben MS Excel MVP


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 do I open a Microsoft Works 95 Spreadsheet with Excel? Mike 68 Excel Discussion (Misc queries) 1 October 10th 05 04:03 PM
How can I open an excel spreadsheet if I forgot the password? SheppyShep Excel Worksheet Functions 1 October 1st 05 01:19 AM
Cannot open a shared excel spreadsheet Kaj Excel Discussion (Misc queries) 1 January 13th 05 02:29 AM
How do I open an attachment (spreadsheet) from someone using offi. Trying to open attachment. Excel Discussion (Misc queries) 2 December 8th 04 06:18 PM
How do I force a hyperlink in a spreadsheet to open a new window? sq246 Excel Worksheet Functions 0 November 18th 04 11:53 PM


All times are GMT +1. The time now is 05:29 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