ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel -- Can't undo [Read-Only] Files. (https://www.excelbanter.com/excel-worksheet-functions/189821-excel-cant-undo-%5Bread-only%5D-files.html)

Paul Marshall

Excel -- Can't undo [Read-Only] Files.
 
The Read-Only has attached itself to files. Going to Properties shows the
Read-Only box is NOT checked. How do I rid myself of this blight?

Dave Peterson

Excel -- Can't undo [Read-Only] Files.
 
Are you opening files that are located on a network drive?

If someone else has the file open, then you may have opened the file in readonly
mode.

If you don't have access to write to that drive/folder, then excel is smart
enough to open the file in readonly mode.

Paul Marshall wrote:

The Read-Only has attached itself to files. Going to Properties shows the
Read-Only box is NOT checked. How do I rid myself of this blight?


--

Dave Peterson

Gord Dibben

Excel -- Can't undo [Read-Only] Files.
 
What is the exact message you are getting?

Are you opening files from external media like a CD?

Or...................

When you are working on an Excel workbook(file) Excel will create a temporary
copy of that file.

Generally when you close the file the temporary is deleted.

Sometimes it is not.

Then you will get the "this file is locked for editing by username".

Most times a re-boot will clear it up but sometimes you must clear your Temp
folder and/or the folder

C:\Documents and Settings\username\Application Data\Microsoft\Excel


Gord Dibben MS Excel MVP

On Tue, 3 Jun 2008 08:13:00 -0700, Paul Marshall <Paul
wrote:

The Read-Only has attached itself to files. Going to Properties shows the
Read-Only box is NOT checked. How do I rid myself of this blight?




All times are GMT +1. The time now is 08:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com