I have Windows 7 installed on two PCs. One runs W7 Prof 64 bit, the other W7 Home 32 bit. I also have Office 2007 SP2 installed on both PCs. I have been sent an xls spreadsheet created by some third party accounting software and every time I try to open it I receive a message warning me that the file contains unreadable content. When I try to repair the file I am told that the file is corrupt.
Now the rub. On the same PCs OpenOffice can open the file with no problem. If I then resave the file as an xls file without making any other changes, I can open the file with Excel 2007.
I can also open the file dirrectly without any difficulty on a PC running Vista and Office 2003 and on a PC running XP and Office 2007.
The only PC I have the problem on is one running Window7. Can anyone offer an answer? To me it would seem to be something in W7 causing the problem.
Your answer is right there in your question, it is the problem with the file created by the third party accounting software.The annoying thing is it works correctly with Office 2007 on XP and Vista, meaning it is extremely difficult to debug the 3rd party code (binary XLS file generation).
This does not work and would not scale on an enterprise level. Is there a patch for this issue?
I have Windows 7 installed on two PCs. One runs W7 Prof 64 bit, the other W7 Home 32 bit. I also have Office 2007 SP2 installed on both PCs. I have been sent an xls spreadsheet created by some third party accounting software and every time I try to open it I receive a message warning me that the file contains unreadable content. When I try to repair the file I am told that the file is corrupt.
Now the rub. On the same PCs OpenOffice can open the file with no problem. If I then resave the file as an xls file without making any other changes, I can open the file with Excel 2007.
I can also open the file dirrectly without any difficulty on a PC running Vista and Office 2003 and on a PC running XP and Office 2007.
The only PC I have the problem on is one running Window7. Can anyone offer an answer? To me it would seem to be something in W7 causing the problem.
Your answer is right there in your question, it is the problem with the file created by the third party accounting software.
I have Windows 7 installed on two PCs. One runs W7 Prof 64 bit, the other W7 Home 32 bit. I also have Office 2007 SP2 installed on both PCs. I have been sent an xls spreadsheet created by some third party accounting softwareand every time I try to open it I receive a message warning me that the file contains unreadable content. When I try to repair the file I am told that the file is corrupt.
Now the rub. On the same PCs OpenOffice can open the file with no problem. If I then resave the file as an xls file without making any other changes, I can open the file with Excel 2007.
I can also open the file dirrectly without any difficulty on a PC running Vista and Office 2003 and on a PC running XP and Office 2007.
The only PC I have the problem on is one running Window7. Can anyone offer an answer? To me it would seem to be something in W7 causing the problem.
Your answer is right there in your question, it is the problem with the file created by the third party accounting software.
Why is this an answer? The OP states that the file opens in Excel 2007 on Win XP and in Excel 2003 in Win Vista but not in Excel 2007 on Win 7. So, what is it about Excel 2007 and Win 7 that it cannot open a file that the other Excel-Windows combinations can open? Tushar Mehta (Technology and Operations Consulting)
www.tushar-mehta.com (Excel and PowerPoint add-ins and tutorials)
Microsoft MVP Excel 2000-Present