Open XML format SDK 2.0

Question

Hi 
I am facing an MS Office Compatibility issue installed on my Users Computers.I am referencing the Open XML format SDK version 2.0 (dll) in my application for an export to excel functionality. When the excel sheet is opened in MS Office 2007 I get the following dialog prompt

"Excel found unreadable content in 'filename.xlsx'. Do you want to recover the contents of this workbook? If you trust the source of this workbook,click Yes." 

When I click "Yes" the excel opens but the hyperlinks that has to be present is removed. However this  
opens without any issue in MS Office 2010 though. 

Does anyone have any Idea on this?

Thanks,

Ashik

Answer 1

I've found a thread

OpenXML Excel file, works in Excel 2007, OpenOffice, etc but not in Excel 2010

You can see whether it helps.

---

with regards, Yuri

Answer 2

Hi Ashik

Try creating - by hand - a spreadsheet in Excel 2007 that contains only a hyperlink like the kind you want to use.

Do the same in Excel 2010.

Now compare the Open XML of both spreadsheets and see how/if it differs.

Things do change from version to version. Usually, a newer version can work fine with files created in an older version, the reverse is sometimes not true. If Excel 2007 and 2010 create hyperlinks differently you'll need to use the commands relevant to Excel 2007 when creating your files if you need them to be compatible in both versions.

---

Cindy Meister, VSTO/Word MVP, my blog