Workbooks Opening as Read-Only

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


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:

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

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


Converting Text Into a Table

You can easily convert regular text into a table using a couple of different methods. This tip explains how to make the ...

Discover More

Searching for Footnote and Endnote Marks

Do you want to quickly search for any footnote or endnote marks in your document? Word makes it easy using the standard ...

Discover More

Formatting In Your Outline

Don't like the formatting that appears when looking at your document in Outline view? You can turn off the formatting and ...

Discover More

Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!

More ExcelTips (ribbon)

Discovering Dependent Workbooks

When you starting linking information from one workbook to another, those workbooks become dependent on each other. ...

Discover More

Creating Individual Workbooks

Workbooks can contain many worksheets. If you want to pull a workbook apart and create a whole series of workbooks based ...

Discover More

Saving All Open Workbooks

Wouldn't it be nice to have a single command that would save each of your open workbooks, all at once? It's easy to do ...

Discover More

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

View most recent newsletter.


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 8 - 4?

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

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

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.