Written by Allen Wyatt (last updated May 15, 2021)
This tip applies to Excel 97, 2000, 2002, and 2003
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.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
Ever want to see a list of all the workbooks that are open? If you open more than nine, Excel only displays the first ...
Discover MoreYou already know that you can define names that apply to different ranges of cells and other elements such as formulas. ...
Discover MoreIf you are opening a workbook and Excel seems to hang without ever fully loading, it could be due to a number of ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
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.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments