Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Double click Excel file may not work

30 Jan 2013   #1
zarknoid

Windows 7
 
 
Double click Excel file may not work

I'm using Windows 7 and Office 2007 and Excel is having this issue. When I double click a particular Excel spreadsheet I get the following error:

Excel cannot access 'FILE.xls'. The document may be read-only or encrypted.

I click OK. Then :

'FILE.xls' cannot be accessed. The file may be corrupted, located on a server that is not responding, or is read-only.

I click OK

This does not happen in all cases. Some Excel files can be opened with a double click. Some files work OK. With this file,if I open Excel first then select the file using file->open the file loads fine. I have checked the file association, it's fine. I've checked the file attributes, it's not flagged read-only.


My System SpecsSystem Spec
.

31 Jan 2013   #2
UsernameIssues

W7 Pro SP1 64bit
 
 

Welcome to the Seven Forums.

Make a copy of the problematic file and keep it in a safe place.

Open Excel and then open the problematic file using File > Open
Save the file as an XLSX file.
Close Excel

Open Excel and then open that XLSX file using File > Open
Save the file as an "Excel 97-2003 Workbook" XLS file.
Close Excel

Test opening the XLS version just saved via double click.
My System SpecsSystem Spec
31 Jan 2013   #3
zarknoid

Windows 7
 
 

When I attempt this it tells me it will remove the VBA code from the file. I do want to retain the VBA code but tried your suggestion anyway. It still brings up the same errors.
My System SpecsSystem Spec
.


31 Jan 2013   #4
UsernameIssues

W7 Pro SP1 64bit
 
 

Is this file on a server? If so, what happens if you copy it to your desktop?
My System SpecsSystem Spec
01 Feb 2013   #5
zarknoid

Windows 7
 
 

It's not a network file. It's in a directory on my C: drive under My Documents

Interesting though it does work on my desktop, but not from the My Documents directory. So I would assume it's something with that directory or inherited rights?
My System SpecsSystem Spec
01 Feb 2013   #6
UsernameIssues

W7 Pro SP1 64bit
 
 

Googling one of the errors that you mentioned showed a few returns pointing to this being a permissions issue - specifically a file ownership thing. You can try taking ownership if you wish.
My System SpecsSystem Spec
04 Feb 2013   #7
zarknoid

Windows 7
 
 
Ownership

I took ownership of the file, but still get the same errors. I am logging into a network profile, if that makes any difference.
My System SpecsSystem Spec
04 Feb 2013   #8
UsernameIssues

W7 Pro SP1 64bit
 
 

Do you have another computer that you can test this on?
Can you make these errors happen with a file that can be uploaded to the forum?
My System SpecsSystem Spec
05 Feb 2013   #9
zarknoid

Windows 7
 
 
Tried Already

Yep, tried the file on another computer and it worked fine.
My System SpecsSystem Spec
05 Feb 2013   #10
zarknoid

Windows 7
 
 
On a side note

On a side note, I was unable to save a Word 2007 file if I double click opened it today. It turned out to be an add-in. Microsoft Fix It found that issue. Probably an Adobe update yesterday did that. I might try turning off add-ins on Excel.

Update: Disabled Add-ons in Excel and it made no difference. Additional note. Created a Microsoft Project file yesterday. No problems with it. Today it gave errors opening a temp file and crashed back to desktop. Opening MS Project, then opening the file from the menu selection works fine.

Could something be messed up in the file association system but not the icon properties?
My System SpecsSystem Spec
Reply

 Double click Excel file may not work




Thread Tools





Similar help and support threads
Thread Forum
automatic delete file when double-click
hi all... thanks for view this thread... i really need anyone here to solve my problem.. the problem is when i double click any file to open it, it always change to delete the file and something like this come out.."are you sure you want to move this file to Recycle Bin?" and it come out...
General Discussion
Change double click ACTION - not merely the file association
I'll attempt to be as clear as possible when explaining my goal - a goal I was able to achieve with Windows XP, but have yet to learn the Windows 7 way. I have a file named whatever.rar. If I double click on the file, WinRAR opens the file and shows me what it contains. This is not the action I...
Customization
Double-click and enter do not open pdf, rtf file associations
w/Win7 x64/sp1 The .pdf and .rtf associations are set correctly to Adobe Reader and Wordpad but double-click or enter only responds by opening Windows Explorer. The right-click context menu lists "Open with Adobe Reader X" correctly and certainly works but is not how I'm used to working for the...
General Discussion
right click on file, open file not work but double click does?????
Just rebooted and nos when i rt click on file icon on the desktop nothing BUT when double click file opens???
Performance & Maintenance
double click on folders doesn't work
When double click on folders I get the pop up window with the message; This file does not have a program associated with it for performing this action. Please install a program or, if one is already installed, create an association in the Default Programs control panel. But if I right click on...
General Discussion
Double click on media file, does not play immediately
Windows 7x64 Ultimate machine - When I double click on a media file of any sort (MP3, WMV, AVI, etc) from Explorer the window that would play the file comes up and then immediately OVER that window the Windows Media Player library comes up, pauses for 5-10 seconds, doesn't display anything then...
Sound & Audio

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 09:33.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App