I want to make changes in excel Any help

Asked By mary mark 0 points N/A Posted on - 11/03/2011

Hi all,

Whenever I try to change an Excel file that I copied from a CD, Microsoft Excel would tell that it is only a Read-Only file.

Is there any way I could copy the Excel file that would without it being a Read-Only file?

I hope you can help me.

Thank you.

• Status: Open
• Question Views: 852
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Microsoft Others

Best Answer by Sharath Reddy

Go To Solution

Best Answer

Best Answer

Answered By Sharath Reddy 590495 points N/A #113654

I want to make changes in excel Any help

All files that are copied and burned into a CD-R disc are automatically set to read-only file attribute.

Even if you don’t set it in your CD burner software, Windows sets this read-only file attribute automatically on all the files that are burned into the CD-R disc.

And besides, I didn’t find any option in any CD burner application to disable the read-only attribute. That’s why copying a file from a disc using Windows Explorer will generally copy the file and retain its file attribute.

That’s the reason why the file is set as Read-Only when you opened it using Microsoft Office Excel.

To remedy this, each time you copy a file coming from a CD-R disc, always change its file attribute. Here’s how you can remove the Read-only attribute of the file:

1. In your Windows Explorer, right click the file that you copied from the CD-R disc and then select Properties.
2. Under Attributes, uncheck the Read-only option and then click Apply then OK.

 

Try opening the file in Microsoft Office Excel again. You will notice that the Read-Only attribute of the file is gone.

You can now normally edit and save the file again.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 11/03/2011
• Question Category: Microsoft Others

Answered By Mark Kellen 0 points N/A #113655

I want to make changes in excel Any help

Hi Mary,

By default your CD – drive sets files you copy/paste to read only setting.

Its like Sharath has put it, burning by default sets it to read-only.

What you need to do is, before you open the file,

right click and check the properties of the file.

If the read only property is ticked on, then you have to un-tick it.

The best way to avoid this problem in the future,

is make sure you check your default settings

and have the files burned as not read-only/protected CD/DVD drive.

Kind regards

Mark Kellen

About Mark Kellen

Questions
0

Answers
11

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 11/03/2011
• Question Category: Microsoft Others