Unwanted Read-Only Workbook Status

by Allen Wyatt
(last updated October 19, 2013)

Marlene has a workbook that is on a USB memory stick. It is used to track fitness data, such as measurements, weight loss, and so on. It is on the memory stick so she can take it with her to various workout locations. The problem is that Marlene recently tried to open the workbook, and Excel reports that the file is "read-only," even when she did nothing to the file to cause the change. Checking the file's properties in Windows revealed that it is not set as read-only, but Marlene doesn't know how to make the workbook, once again, usable.

The root of this problem is that when the workbook was opened a few weeks ago, Excel was exited after removing the memory stick from the computer. This caused the file to be left in a read-only state because Excel didn't have a chance to do its normal "shutdown" on the file.

There is no way around this problem. The solution is to open the file as read-only and then save the workbook with a new name. You can then delete the original workbook, and the new workbook can be used successfully. In the future you'll want to make sure to give Excel ample time to shut down the workbook before removing the memory stick from the drive.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2898) applies to Microsoft Excel 97, 2000, 2002, and 2003.

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

Equation Editor Font Color

If you want to change the color used by the Equation Editor, you may be out of luck. In fact, the best solution may be to ...

Discover More

Enhanced Filling

Using the AutoFill feature of Excel is very handy. If you want to expand the utility offered by the feature, all you need to ...

Discover More

Easily Adding a Graphic to a Document

Need to spice up your document with a graphic? Here's the quickest way we've found to get those graphics where you want them.

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

MORE EXCELTIPS (MENU)

Printing a List of Named Ranges

You already know that you can define names that apply to different ranges of cells and other elements such as formulas. ...

Discover More

Forcing a Workbook to Close after Inactivity

Tired of your workbooks being left open on the screen where they can be seen by anyone passing by? Here's a way to have Excel ...

Discover More

Problems with Default Workbook and Worksheet Templates

You can create a default template for both your workbooks and worksheets. These should be placed in the xlstart folder, but ...

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 for this tip:

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)

This Site

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

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.

Links and Sharing
Share