I'm trying to access a 2003 formatted Excel spreadsheet in .NET. I have the process completed, and it's pretty straight forward by accessing the sheet and process the data. It works perfectly. The only problem is that Office 2007 Excel is encrypting these documents.
Now, it has some odd behaviors. It seems to be encrypting the documents if the user click Prepare > Encrypt Document. When the dialog appears, there is some sort of default pw in the field. If the user clicks OK, it doesn't bring up the re-entry dialog to confirm, so I wonder if it is flagging the document.
My questions are:
Is it defaulting these documents? Is there a way to decrypt an Excel file in Excel 2007 that has already been encrypted? Any ways around this?
I continue to get the "Could not decrypt file", but these files do not ask for a password upon opening.