?
Solved

Excel 03 file will not open in Excel 2007

Posted on 2008-10-09
16
Medium Priority
?
1,730 Views
Last Modified: 2012-05-05
All,
Latley we have been having problems with excel files. We are getting .xls files via e-mail and some users who have Office 2007 Standard on an XP Pro PC try to open the file and get the following message:
The file you are trying to open, 'filename.xls' , is in a different format than specified by the file extension. verify the file is not corrupt and is from a trusted source before opening the file. Do you want to open the file now? "Yes, No or Help". If you click on "Yes, it opens excel but the workbook is blank. If you click "no", it closes. and "help" was of no help at all.
However if a user who has Vista Business and Office 2007 standard, they can open the file. Then they save the file and send it back to the user who has the problems and they can then open it.
If you save the file to a local drive or network drive, it is blank "0 KB". I searched the internet and only found how to stop the "yes, no, help" popup.
We use Excahnge 2003 internally.

Any ideas why this is happening?
0
Comment
Question by:DarrylRT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 4
  • 2
  • +1
16 Comments
 
LVL 17

Expert Comment

by:ExcelGuide
ID: 22684732
try the to insert this key in your registry to suppress the notification:

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security]
ExtensionHardening=dword:00000000

You can accomplish the above by doing the following:

Open your Registry (Start -> Run -> regedit.exe)
Navigate to HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL\SECURITY
Right click in the right window and choose New -> DWORD
Type ExtensionHardening as the name (without the quotes)
Verify that the data has the value 03

good luck
0
 
LVL 1

Expert Comment

by:tyro7866
ID: 22684900
Download Microsoft Office Compatibility Pack for Word, Excel and PowerPoint 2007 at Microsoft website.

http://www.microsoft.com/downloads/details.aspx?FamilyID=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en

you will be ok
0
 
LVL 1

Expert Comment

by:tyro7866
ID: 22684910
or try this freeware

http://www.nativewinds.montana.com/software/docx2rtf.html#download 

convertd doc to docx to doc or the opposite.

good luck.
0
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 1

Author Comment

by:DarrylRT
ID: 22686066
Psychotec, I have tried your soultion, but it only bypasses the popup, and still opens blank.

Tyro7866, Your suggestions are for users running older office (2003) trying to open a 2007 file. My users are running 2007 office and need to open a file that is from 2003 office. However I installed the compatability pack anyway to see if it would solve the problem and it did not.

Thank you for your suggestions!
Darryl
0
 
LVL 1

Author Comment

by:DarrylRT
ID: 22799150
The problem is with Outlooko 2007. An e-mail with an Excel attachment that is sent to a user can not be opened. I does not matter if the e-mail is in the inbox, sent items or deleted items. However if the user clicks on Forward and then doubleclicks on the file, it will open. Anyone have a thought?
Thank you,
Darryl
0
 
LVL 1

Author Comment

by:DarrylRT
ID: 22799165
increades point value to 500. This is happening on more PC's now. Even with a fresh install.
0
 
LVL 21

Expert Comment

by:GlennaShaw
ID: 22800009
Have you installed SP1?  And try installing the compatibility pack anyway.  It won't hurt and I think it's supposed to automatically install with 2007.
0
 
LVL 1

Author Comment

by:DarrylRT
ID: 22811858
GlennaShaw,
I have verified that SP1 is installed and I installed the Compatibility pack as well. This did not change anything. Excel opens with a blank page.

Darryl
0
 
LVL 21

Expert Comment

by:GlennaShaw
ID: 22816257
0
 
LVL 1

Author Comment

by:DarrylRT
ID: 22824094
GlennaShaw,
I have gone over that artical twice now and did everything in it. Still no luck. If you try to preiew the file it does not open as well.
Darryl
0
 
LVL 21

Expert Comment

by:GlennaShaw
ID: 22826687
0
 
LVL 1

Author Comment

by:DarrylRT
ID: 22888578
It seems that Symantec endpoint 11.0.2010.25 is the problem. If I disable the program, the problem goes away. If I enable it again it comes back. I called Symantec about this and they are aware of this issue. They do not yet have a fix for it (as of today). They do hope to have a fix by the end of the year (as per the tech on the phone). The upgrade will be 11.0.4000. Until then the only solutions are to:
1. click on Forward (do not click on send) and then doubleclicks on the file, it will open.
2. in Symantec Endpoint, Change settings, Configure settings (for Antivirus and Antispyware Protection), outlook auto-Protect, Uncheck "enable microsoft outlook Auto-Protect".
Thank you all for your suggestions and comments.
0
 
LVL 1

Accepted Solution

by:
DarrylRT earned 0 total points
ID: 22960176
I have updated the Symantec Endpoint to 11.0.3001.2224. Then I added the check to the "enable microsoft outlook Auto-Protect". The users were able to open the file with no issues. Now the problem has gone away. Thank you to all who offered there suggestions.  
0
 
LVL 21

Expert Comment

by:GlennaShaw
ID: 22960470
Please accept your finding as the correct answer so folks who are searching here can find it.  And thanks for sharing!
0
 
LVL 1

Author Comment

by:DarrylRT
ID: 22960537
GlennaShaw,
I have accepted my post as the solution. I have done so twice.
 
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question