Question about Microsoft Excel for PC

4 Answers

Excel file opens in read only mode

A friend of mine has an excel file that opens in read only mode, what does he change to be able to open the file in edit mode?

Posted by on

  • masudur Jan 29, 2009

    I can't open mt MS Excel file

×

4 Answers

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 32 Answers

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!

Posted on Jan 28, 2009

  • 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.
This is a duplicate post.

Posted on Jan 28, 2009

  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that got 5 achievements.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Contributor
  • 40 Answers

Hello,
Tell your friend to, right click on the file name, then go to "Properties".
On the General tab, at the bottom, see if the checkbox for "Read-only" is selected. If so, uncheck this option and click Ok. The file should now be editable. If this does not work and the file was sent from someone else, ask them to follow the steps above, then resend the file back to your friend.
Let me know if this helps.
Thanks, Raph30

Posted on Jan 28, 2009

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Champion:

    An expert who has answered 200 questions.

    Governor:

    An expert whose answer got voted for 20 times.

  • Microsoft Expert
  • 401 Answers

You may only works with excel files by the aiding of xlsx corrupt file fixer

http://www.xlsxfixer.excelfilefixer.com

Posted on Sep 08, 2013

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

3 Answers

Cannot open file. Error message reads: Excel cannot open


Use Excel Repair Toolbox is efficient corrupt XLSX file repair software, suitable for all data recovery activities, applied to Microsoft Excel documents.

For more: https://www.xlsxrepairtoolbox.com/

Aug 03, 2015 | Microsoft Excel for PC

3 Answers

Excel workbook error


I came across this issue today. An update to the Office Compatibility Pack that was still on a computer caused the default PROGRAM for .docx and .xlsx files to be the Microsoft Open XML Converter program and make the "Default Programs" in Control Panel think that Excel and Word were actually the Microsoft Open XML Converter scholarship essay writing assistance program as well.UNINSTALLING the Office Compatibility Pack in Programs and Features and then a simple reboot fixed the issue.
Also:
1: Try to repair it manually when MS Excel does not automatically STARTS File recovery mode.
Click the Microsoft Office Button, and then click OPEN.
Now select the corrupted workbook that you want to open.
Click the arrow NEXT to the Open button, and then click Open and Repair.
Choose either Repair (to recover as much of the FILE data) or Extract data (to extract values and formula when repair process is not successful).
2: Open with Open Office: Try to open your Excel file in Open Office. It is an open-source Office suite that is able to open & SAVE Microsoft Excel files.
3: Save in HTML Format: Open your Excel file and save it in HTML format. By saving the workbook in HTML format, you may be able to filter out the corrupted elements.
4: Save in SYLK Format: Open your Excel file and save it in SYLK format. By saving the workbook in SYLK format, you may be able to filter out the corrupted elements.
5: Try 3rd party software like Excel Repair Toolbox
link: https://www.repairtoolbox.com/excelrepair.html

Jun 18, 2015 | Microsoft Office Excel 2007

1 Answer

Excel 2003 worksheet slow in 2007


Hi Lee, I have recently experienced the same thing. When Excel 2007 or later opens an Excel 97-2003 .xls file, there are major issues of speed. The file is opened in compatibility mode. The best thing to do would be to open the file, then save as (keep the same name if you like) an Excel 2007 .xlsx document (or .xlsm document if there are macros). Close the file, then reopen it, and the compatibility mode issue will be gone. You can now use the newly saved file as a normal Excel 2007 file. Hope this helped.

Mar 25, 2014 | Microsoft Office Professional 2007 Full...

1 Answer

I have made an excel file with linked data in MS Office 2007.The file opens in read only mode though it is not open in any other location.


Possibly read only option is checked in file properties.

Right click the file and review the setting. Uncheck the read only box if necessary.

Apr 18, 2011 | Microsoft Excel for PC

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

3 Answers

When i open an excel doc it is only numbers not words


Hi! It probably was created in Excel 2007. You need a converter to open the file.

Sep 18, 2010 | Microsoft Excel for PC

3 Answers

Excel cannot open the file, because the file format or file extension is not valied. Verify that the file has not been corrupted and that the file extension matches the format of the file and error message...


Excel cannot open the file, because the file format or file extension is not valid, this message indicates that your Excel file is get corrupt and its internal signature has been changed thats why ms excel can not read it. Repair it with good excel recovery software to fix your problem.
http://www.stellarinfo.com/excel-recovery.htm

Apr 27, 2010 | Microsoft Office Professional 2007 Full...

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?


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.

Jan 28, 2009 | Microsoft Excel for PC

2 Answers

"unable to read file" message when opening an Excel workbook.


I was sent an excel file (.xls). friends on mac and pc can both open it.

i am on mac and keep getting unable to read error. it must be something with my mac. what could it be? nobody else has this problem.

Jan 03, 2009 | Microsoft EXCEL 2004 for Mac

5 Answers

Microsoft excel file dose not open autometically


hi Friends

here is the solution ifi Excel opens without opening any file after double clicking on the excel file,

1. Tools>Options>General uncheck "Ignore other Applications"
2. Exit Excel and try again
If this doesn't work try to re-register Excel
1. Close Excel first and On the Windows Taskbar
2. Start>Run "excel.exe /unregserver"(no quotes)>OK.
3. Start>Run "excel.exe /regserver"(no quotes)>OK.
See the space between exe and /regserver

if there is anyother issue in which may i help u then feel free to contact me
kamal_lalwani@dell.com
kamal0806us@yahoo.com
+9742128873 /

Jan 23, 2008 | Microsoft Excel for PC

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

9,058 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

18297 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...