Question about Microsoft Excel for PC

1 Answer

A friend of mine is trying to open an excel spreadsheet and each time it opens as a read only file. what can be done so that he can open the file for editing?

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    President:

    An expert whose answer got voted for 500 times.

  • Master
  • 1,901 Answers

Open Windows Explorer (Not Internet Explorer) and locate the file. Right click on the file and select Properties. At the bottom of the General tab, uncheck the Read Only box and click OK.

Posted on Jan 28, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

Excel Corruption files


Without seeing the file, it is difficult to diagnose what is going on, but I will offer some ideas.

What version of Excel are you using? Are you using Excel 2003? Was the file you are trying to open created in Excel 2007 or Excel 2010. If so, it might be using the new format and therefore will not open in Excel 2003 and older.

It is possible the Excel file is data that was imported from a source in which Excel cannot import. Does the Excel spreadsheet contain any imported data?
Try to use: XLSX Viewer Tool here : http://www.xlsx.viewertool.com/
Those are the most likely causes of the corrupt data. Is every file you open in Excel corrupt, or just this one workbook? If it is just this one workbook, then, yes, it sounds like it is corrupted. If every file you open with Excel is corrupt, then your version of Excel could be corrupt, but that is unlikely.

Jul 10, 2015 | Microsoft Excel for PC

2 Answers

Excel Error Message.What can I do to stop this error?


A corrupt excel spreadsheet can be repaired by using Open and Repair technique. It is a built-in repair function that opens a corrupt excel file forcefully.
*OpenMS Excel >pressCtrl+O >locate corrupt excel spreadsheet and select it.
*Click on the arrow shown besideOpenbutton>selectOpen and Repair.
It will take just a few seconds to be completed and selected file will be opened, if possible.

Or if this doesn't work, one may take help of a third-party

For example Excel Fix Toolbox
https://www.fixtoolbox.com/excelfix.html

Apr 24, 2015 | Microsoft Office Excel 2007

1 Answer

I WOULD LIKE TO CHANGE MY EXCEL FILE IN READ ONLY MODE


amjbritto,

There are two ways to do this, depending on what extent you want to protect the spreadsheet.

Windows Read-Only method:
  1. Save and Close the Excel file.
  2. Using Windows Explorer, locate the Excel file in its folder.
  3. Right-click on the file name
  4. Click on "Properties" at the bottom of the drop-down window.
  5. Check the [x] Read-Only box and [OK]
  6. * DONE *
Excel "Protect" Method:

  1. Open the Excel spreadsheet that you want to protect
  2. On the top menu, select [Tools]
  3. Click [Protection] on the drop-down menu
  4. Select [Protect Workbook]
  5. Check [x]Structure and [x]Windows
  6. Enter a password if you wish, but remember it!
  7. Click [OK]
  8. Save and close the spreadsheet and test the protection.
  9. *DONE *
Thanks for using FixYa.

Oct 06, 2010 | Microsoft Excel for PC

8 Answers

Password forgotten to acces my excel spreadsheet


Type "excel password recovery" into Google and you'll have a choice of many suppliers who sell software that will reveal an Excel password. I have tested most of their free trial version .Excel password recovery 5.0 is my favourite one,it is 100% recovery rate and easy to use.and most of all,it is the cheapest.just have a try

Jul 14, 2010 | Microsoft Excel for PC

1 Answer

My excel file was working yesterday, but as of


Shouldn't be a date issue... did you open the file the way you normally do ?
Something has changed here... bad shut down with this file opened... maybe.
Open Excel and pull down the File Menu and see if there are more than copy or version of your spreadsheet. Look at all...
File could have corrupted the Font or could be a Virus. Try just changing the font in one cell.
If this is your only copy of the file... make a copy to see if it works on another machine... that will isolate the problem... it may just be corrupt... the fix is Excel healing it on it's own when it opens.

Jan 01, 2010 | Microsoft Excel 2003 (065-03992) for PC

8 Answers

Repair corrupt excel file


Don\'t need to worry even if your excel
files are get corrupt because there are several ways to repair
corrupt excel files. The easiest available solution is to use "Open
and repair" utility of MS excel to repair damaged xlsx or xls files.

Jul 10, 2009 | Microsoft Office 2003 Professional Full...

2 Answers

Excel data is Delimited


Try opening the file from the Excel File/Open menu rather than double clicking to open it.  If that does not work try Importing from it into a new blank spreadsheet.

Jun 01, 2009 | Microsoft EXCEL 2004 for Mac

4 Answers

Excel file opens in read only mode


Hello,

There could be 1 of 3 things affecting this:

1. Is another application using that excel document? If so you will not be able to edit it until the other application stops using it.

2. Is the file currently in a location that you do not have write permissions? eg. another users shared documents

3. Check in the properties to see if it is set to read only. (right click on the document and click properties. in the 'General' Tab see if 'Read Only' is checked. If yes, uncheck it and click okay)

An easy way to make it editable providing you are the only one using it (If the above fixes dont work) open it up in excel and then click File --> Save As... and then save it somewhere else. That will then make it editable for you.

Have a Great Day!

Jan 28, 2009 | Microsoft Excel for PC

1 Answer

I cant open Excel speadsheet file


try to open the file from excel Open excel 1st the locate your spreadsheet file from File Open menu.
if your still getting same problem try open using google docs, click this link http://docs.google.com you need a gmail account to use this facility. (google docs is the counterpart of MS Office, its Free to use and web base)

Nov 18, 2008 | Microsoft Office Standard for PC

2 Answers

Import data from access into excel where one column go into one worksheet and other into next


Can't be done.

Access will only put the data into one worksheet. It is very picky when it comes to exporting data into an Excel spreadsheet.

There are two ways to get around it:

1) You can export the data from Access into two files. One for the the first worksheet and another file for the second workshet.

2) You can import everything into one spreadsheet and build a macro into Excel to cut the information one spreadsheet and paste it into the other if this is a redundant task to do all the time.

Hope that helps you out.

Jun 10, 2008 | Microsoft Office Access 2003 (077-02871)...

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

85 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...