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

Replacing Text with a Graphic

The Find and Replace feature in Word provides you with some powerful tools you can use to process a document. One such tool ...

Discover More

Sorting Comments by Date

Want to see a list of document comments in chronological order? Word doesn't include such a capability, but there are ...

Discover More

Automatic Numbers with Leading Zeroes

Word's automatic numbering formats allow you to easily create lists that have one leading zero. If you want more than one ...

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)

Renaming a Workbook

Renaming a workbook from within Excel can seem daunting, but it is actually quite easy. All you need to do is use the Open ...

Discover More

Closing All Open Workbooks

Excel provides a handy (but little-known) shortcut for closing all the workbooks you have open. This tip explains how easy it ...

Discover More

Turning Off Sharing

All good things must come to an end at some point. When you are done sharing your workbook with others, this is how you can ...

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:

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}] in your comment text. You’ll be prompted to upload your image when you submit the comment. 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 nine more than 2?

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


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.

Links and Sharing
Share