Skip to Content
author's profile photo Former Member
Former Member

filename.xls is in a different format than specified by the file extension

When I create Dimensions and then try to maintain dimension members using the administration client, I receive the following notification from Excel 2007. The file you are trying to open, filename.xls, is in a different format that specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now? Yes or No.

I click yes and the file opens correctly in Excel. If I click No, I get an "Unspecified error" dialog box from BPC. I suspect this is a security feature in Excel 2007. Has anyone else run across this and if so, know of a good way to disable this message?

Adam

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 01, 2008 at 09:57 PM

    Hi!

    Just to let you know... I reported this today as a bug at SAP...

    We are having the same problem with Excel 2007.

    Just for your info, there is a Microsoft thing to install for compatibility issues with Excel 2003 and 2007.

    Google this you will find it on MS website. It is a thing to install on 2003 clients...

    But I do not know if it solves the problem... I will let you know when I have a feedback from SAP or a solution.

    Nic

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 18, 2011 at 10:38 AM

    After upgrading to Excel 2007, you may get the following error when you try to open an excel document.

    The file you are trying to open .xlsx is in a different format than specified by the file extension. verify the file is not corrupted and is from trusted source before opening the file. Do you want to open the file now?

    This errors particularly occurs when youu2019re trying to open an XLS file (Excel 2000-2003) with Excel 2007.

    The easiest way to solve this problem, is to insert the following registry key. This will suppress the notification:

    [HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security]

    u201CExtensionHardeningu201D=dword:00000000

    The step-by-step instructions are as follows:

    1.Click Start, click Run, type regedit.exe and press ENTER. This will open your Registry

    2.Navigate to HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL\SECURITY

    3.Right click in the right window and choose New -> DWORD

    4.In the Name field, type u201CExtensionHardeningu201C (without the quotes)

    5.Verify that the data has the value u201C0u2033

    I advice the steps above to solve the problem, despite the fact that it is quick and dirty.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.