Workbooks Opening as Read-Only

Written by Allen Wyatt (last updated February 25, 2023)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, 2021, and Excel in Microsoft 365


2

Loren recently purchased a new computer and now Excel insists that he open most of his old workbooks in read-only mode. That becomes a problem when saving in that it forces Loren to save as "Copy of" instead of updating the previous file. He wonders if there is a way to fix this.

Given that you have this problem with files transferred from your old computer to the new one, there are two primary things you should check. First, you need to get out of Excel and, in Windows, locate your old workbooks. Right-click on each of them, in turn, and choose Properties from the resulting Context menu. Windows then displays the Properties dialog box for the file. At the bottom of the information on the General tab of the dialog box you can see if Windows has marked the file as Read-Only. Clear the check box, if necessary, and then click the OK button.

If that doesn't do it for you, then check to see if the workbooks are using the XLS format, which is the file format for very old workbooks. If this is the case, then your new version of Excel on the new PC may be set to "distrust" the old-format XLS files. Check to see if this is the case by following these steps:

  1. Display the Excel Options dialog box. (In Excel 2007 click the Office button and then click Excel Options. In Excel 2010 and later versions display the File tab of the ribbon and then click Options.)
  2. Click Trust Center at the left of the dialog box.
  3. Click the Trust Center Settings button. Excel displays the Trust Center.
  4. At the left side of the dialog box click File Block Options. (See Figure 1.)
  5. Figure 1. Setting the file blocking options.

  6. If there are check marks beside the Excel 97-2003 file types, clear these.
  7. Click OK to close the Trust Center dialog box.
  8. Click OK to close the Excel Options dialog box.

If the check boxes in step 5 were already clear, then you may want to check the trusted locations that can be specified in the Trust Center. (Before closing the Trust Center in step 6, click Trusted Locations at the left side and make sure that the folder in which the workbooks are located is listed.)

There are additional reasons that a workbook might always open as read-only, but those are unlikely to be reasons in Loren's case. If, however, you would like to read about those other reasons, you may find this blog post informative:

https://blog.golayer.io/excel/how-to-remove-read-only-from-excel

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (13022) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, 2021, and Excel in Microsoft 365.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Restoring the Analysis ToolPak

Add-ins for Excel, such as the Analysis ToolPak, are stored in files on your hard drive that can be deleted. If you ...

Discover More

Margins for All Documents Changing

Have you had the margins in a group of documents change without you knowingly doing anything? This tip explores some ...

Discover More

Selecting a Bookmark in a Macro

Bookmarks can be very handy in a document. Word provides a VBA command you can use to easily select any of those bookmarks.

Discover More

Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!

More ExcelTips (ribbon)

Opening a Workbook to a Specific Worksheet

When you open a workbook, Excel displays the worksheet that was visible when the workbook was last saved. You may want, ...

Discover More

Creating a Workbook Clone

If you are afraid of messing up a workbook, consider doing your work on a clone of the workbook. Excel provides an easy ...

Discover More

Changing Links

If your worksheet is linked to data in other worksheets, you may need to change the link from time to time. Here's how to ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] (all 7 characters, in the sequence shown) in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 2 + 8?

2023-02-25 09:56:08

J. Woolley

@Rick Emmertson
"Due to Windows security settings, files that you get from the internet might not work correctly, unless you unblock them, or store them in a Trusted Location."
See https://www.contextures.com/excelfiles.html#unblock


2023-02-25 08:07:35

Rick Emmertson

My MS 365, Excel will open a .xlsx file emailed to me by a customer. Above the workbook, it has a yellow box, with a message, "PROTECTED VIEW Be careful---files from the internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View." followed by a click box labeled "Enable Editing" Is there a way to check for malware before enabling editing? (see Figure 1 below)

Figure 1. 


This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.