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

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

By the way, I have a workaround like this: try to save it as a XLS 2003 format. Then open it with 2003 Excel and put it back on the server... but do not open the Admin dimension members with 2007!!!

Nic

[Former Member · Accepted solution]

This may be related to other Office file issues we are having. One possible workaround is to disable the file extention checking in Office. Extension Hardeing is a new feature in office 2007 and is on by default.

You can disable Extension Hardening by doing the following. This will fix all Microsoft Office products.

1. Open your Registry (Start -> Run -> regedit.exe)

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. Type u201CExtensionHardeningu201D as the name (without the quotes)

5. Verify that the data has the value u201C0u2033

[prakash_lalwani · Accepted solution]

The Solution is very useful. It worked.

Thank you very much.

Regards,

Prashant Amburle

[Former Member]

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.