Opening excel files from windows explorer

flightjock

New Member
Joined
Mar 18, 2002
Messages
48
When I open excel files from the windows explorer they are opened in read-only and a "1" is automatically added to the filename. E.g. when the file in explorer is called filename.xls and is doubleclicked to open it, it is renamed in the Excel title bar to filename1.xls. Opening the file normally from Excel this problem does not occur. Has anyone ever seen this and is there an explanation and a way to prevent it. It must be something on my PC because my colleague has no such problems
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
May I guess you are using Windows 2000 or XP? What has happened is the last time you closed this workbook Windows did not delete the copy of the file it keeps as a most recent document or backup file. When you open this workbook again, i.e. filename.xls, Windows "sees" a copy in the folder and allows you to open it by adding a 1 to the end of the filename. (If you were using NT 4 you would have gotten an error message with some type of sharing violation.) What you need to do is perform a search on your PC, on all HD's'. Search for the filename that you are looking for but add wild cards on either end, example: *filename*. Now unless you’re an Admin the folder in which these files are stored (something like 1033) won't be visible to you if you search for it through My Computer or Explorer. In fact sometimes the search will return no hits if you are a regular user. If this happens you will have to ask your IT department to log on as an Admin and do this for you. The search will return a few hits of both files and shortcuts. First don't delete the shortcuts yet, delete the extra files (not the one you are working on of course). Then as for the shortcuts, right click on the shortcut and go to Properties. Click on the Shortcut tab. Click on Find Target. In the Explorer window delete the files with the filename you are looking for. Once that is done for each shortcut delete the shortcuts. Now you should to be able to open the workbook with no problems.
 
Upvote 0
I'm not running Windows 2000 or XP. Excel is running on NT but I didn't get a warning as you suggested. I'll try to get our administrator to do what you suggested anyway to see what comes up. Thanks.
 
Upvote 0

Forum statistics

Threads
1,214,375
Messages
6,119,168
Members
448,870
Latest member
max_pedreira

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top