A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

change the read only option



 
 
Thread Tools Display Modes
  #1  
Old October 2nd, 2004, 09:35 PM
phoenix1840
external usenet poster
 
Posts: n/a
Default change the read only option

For safe keeping I copy the file on a CD.
Each time I need to change this file, I get a error message telling me that
its a read only file...
How can I change the setting, so I don't get this error message @ time?
  #2  
Old October 2nd, 2004, 09:54 PM
Dave Peterson
external usenet poster
 
Posts: n/a
Default

Before you open the workbook, copy the file from the CD to your harddrive using
windows explorer.

While you're still in Windows Explorer, rightclick on the harddrive file and
choose properties. On the General Tab, you can remove the ReadOnly attribute.

It's better to open the file from your harddrive than from the CD, too.

phoenix1840 wrote:

For safe keeping I copy the file on a CD.
Each time I need to change this file, I get a error message telling me that
its a read only file...
How can I change the setting, so I don't get this error message @ time?


--

Dave Peterson

  #3  
Old October 2nd, 2004, 10:32 PM
Gord Dibben
external usenet poster
 
Posts: n/a
Default

Phoenix

First of all.......you should never save to or open from removable media
directly.

Save to HDD then copy to the CD. Same when opening. Copy to HDD then open.

The read only bit.......

That is the default behaviour when saving/copying to CD.

All depends upon how the files get "burned" to the CD.

With regular Windows burning, they will always be read-only and you have to
remove the read-only status when you copy back to Hard Drive.

If you were to use a packet writing application like Nero InCD, files would
not be read only and individual files could be erased or written to on the CD
just like a big floppy disk.

See this google search thread

http://snipurl.com/6llq

Note the link to Alex Nicholl's site.

Also http://www.webtree.ca/windowsxp/cdr_info.htm

Gord Dibben Excel MVP

On Sat, 2 Oct 2004 13:35:02 -0700, "phoenix1840"
wrote:

For safe keeping I copy the file on a CD.
Each time I need to change this file, I get a error message telling me that
its a read only file...
How can I change the setting, so I don't get this error message @ time?


  #4  
Old October 2nd, 2004, 11:27 PM
phoenix1840
external usenet poster
 
Posts: n/a
Default

Thank you for your help Mr. Peterson

I think I wasn’t clear enough the first time or you have misunderstood me.

First I am not opening the file from the CD, its only one for safety.

We never know how often we have to reformat pc with Microsoft Windows XP’s
(like once @ second week L)

Let me give you more info:
The file, which I want to safe keep on a CD, is one from Excel; store on the
HD, to be more precise the drive D.
This file, is already save once on a CD (the safe keep file).

Each time I go back into Excel and make changes into this file, I save it
again on the drive D.

I just can’t re-save it again on the same CD for the safe keep, each time I
make changes into the original one.

Each time I try it, I get an error saying this file is read only.

How do I fixt this error message, or what is the setting do I have to change
into Excel 2000 to make the file a read one?

Any more suggestions anyone?


"Dave Peterson" wrote:

Before you open the workbook, copy the file from the CD to your harddrive using
windows explorer.

While you're still in Windows Explorer, rightclick on the harddrive file and
choose properties. On the General Tab, you can remove the ReadOnly attribute.

It's better to open the file from your harddrive than from the CD, too.

phoenix1840 wrote:

For safe keeping I copy the file on a CD.
Each time I need to change this file, I get a error message telling me that
its a read only file...
How can I change the setting, so I don't get this error message @ time?


--

Dave Peterson


  #5  
Old October 3rd, 2004, 02:02 AM
Dave Peterson
external usenet poster
 
Posts: n/a
Default

So it's not the file attribute that's causing the trouble.

Maybe you can fix it from an answer to a FAQ at Debra Dalgleish's site:
http://www.contextures.com/xlfaqApp.html#ReadOnly

ahhh, it's short:

Q. All of a sudden a number of my Excel 2000 files have become "read-only".

A. Clear out c:\windows\temp directory on the machine that houses the files,
then reboot.

Excel stores some files on the windows temp folder. If excel/windows crashes,
some of these files may not be deleted when you close the workbook. And the
next time you open the workbook, excel sees those files in the Windows Temp
folder and assumes that the workbook is already open and in use.




phoenix1840 wrote:

Thank you for your help Mr. Peterson

I think I wasn’t clear enough the first time or you have misunderstood me.

First I am not opening the file from the CD, its only one for safety.

We never know how often we have to reformat pc with Microsoft Windows XP’s
(like once @ second week L)

Let me give you more info:
The file, which I want to safe keep on a CD, is one from Excel; store on the
HD, to be more precise the drive D.
This file, is already save once on a CD (the safe keep file).

Each time I go back into Excel and make changes into this file, I save it
again on the drive D.

I just can’t re-save it again on the same CD for the safe keep, each time I
make changes into the original one.

Each time I try it, I get an error saying this file is read only.

How do I fixt this error message, or what is the setting do I have to change
into Excel 2000 to make the file a read one?

Any more suggestions anyone?

"Dave Peterson" wrote:

Before you open the workbook, copy the file from the CD to your harddrive using
windows explorer.

While you're still in Windows Explorer, rightclick on the harddrive file and
choose properties. On the General Tab, you can remove the ReadOnly attribute.

It's better to open the file from your harddrive than from the CD, too.

phoenix1840 wrote:

For safe keeping I copy the file on a CD.
Each time I need to change this file, I get a error message telling me that
its a read only file...
How can I change the setting, so I don't get this error message @ time?


--

Dave Peterson



--

Dave Peterson

  #6  
Old October 4th, 2004, 12:57 PM
Lady Layla
external usenet poster
 
Posts: n/a
Default

Are you using a CD-R or CD -RW?

"phoenix1840" wrote in message
...
: For safe keeping I copy the file on a CD.
: Each time I need to change this file, I get a error message telling me that
: its a read only file...
: How can I change the setting, so I don't get this error message @ time?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem Updating New Messages from NTTP News Server OE Chad Harris Outlook Express 19 February 7th, 2005 07:21 PM
Where is the option to change the folder where .pst folder are?? Jocelyn Fiorello [MVP - Outlook] General Discussion 1 July 20th, 2004 01:44 AM
Field list greyed out when trying to add an option group Tony Using Forms 1 July 1st, 2004 03:40 AM
Combo Box selection disappearing on new record and change of option selection EmmA Using Forms 2 June 17th, 2004 02:21 AM


All times are GMT +1. The time now is 07:01 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.