LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
rcmodelr
 
Posts: n/a
Default How do I unlock FILE access?

This morning, at work, I was using Excel to track data on trucks at work.
During break, I opened another Excel document to view. Shortly after the
second Excel document was opened, another truck came in. When I tried to go
back to the spreadsheet file to record the info for the truck that came in,
Excel went idle for 30 seconds, then came back with a READ ERROR saying it
had tried reading a memory address that was un-readable. When I clicked OK
on the read error message box, Excel SHUT DOWN COMPLETELY...

When I RE-started Excel, and tried loading the truck info file that was
supposed to be activating when the memory read error occurred, Excel reported
that I (well, MY UserID) was accessing that file elsewhere, and Excel would
therefore ONLY open it as a READ-ONLY file. It gave the SAME "protection"
message when it tried opening my Personals.xla file.

To be able to record the info on the trucks, I had to save the file under a
NEW NAME so the data could be saved.

Afterward, I even tried RE-BOOTING the computer, THEN accessing the file,
and Excel STILL says the Personals and truck file have been RESTRICTED by MY
UserID so they are STILL only accessible in READ-ONLY mode. So I tried
DELETING them with Windows Explorer, which says the files CAN NOT BE DELETED
because my userID has restricted access to these files through Excel.

How can I get Excel AND Windows to REMOVE the protection from these NO
LONGER NEEDED files? I have a couple new macros to add to my Personals file,
but Excel won't allow me to do so, stating that the Personals file is already
in use BY ME so it can be opened ONLY in READ-ONLY mode, and I CAN NOT save
it if I want to.
 
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
File in C drive is always trying to access Drive A Andre Croteau Excel Discussion (Misc queries) 3 August 9th 05 01:13 PM
how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro. Daniel Excel Worksheet Functions 1 June 24th 05 02:59 PM
Cannot access a file -- HELP Steve Excel Discussion (Misc queries) 2 June 15th 05 08:05 PM
Importing Access File with Hyperlink B.C.Lioness Excel Discussion (Misc queries) 0 April 29th 05 10:13 PM
Network access to file - read only property AL Excel Discussion (Misc queries) 1 December 2nd 04 01:22 AM


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

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

About Us

"It's about Microsoft Excel"