I've got this big bad program all written up and everything works. But when i read in the excel sheet using oledb and c#, for some reason, the sheet cannot load unless the sheet is open in excel.
The error I get is:
System.Data.OleDbException (0x80004005): External table is not in the expected format
But it works just fine if the file is open in excel when i run the c# app. Weird. Don't whats going on.