Print Page | Close Window

Error - Excel 2010 and Crystal

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11666
Printed Date: 19 May 2024 at 3:27am


Topic: Error - Excel 2010 and Crystal
Posted By: Zuzanna
Subject: Error - Excel 2010 and Crystal
Date Posted: 12 Nov 2010 at 9:49am
Hello,
 
we just recently upgraded from Excel 2003 to Excel 2010. We have a crystal report that read an Excel file. After the upgrade when we try to run it, we receive an error message OBDC Error: MS engine could not find the object.
We converted the Excel file from 2003 to 2010 and the name hasn't changed. The only thing that's different is that the Excel file used to be .xls and now is .xlsx.
Has anyone run into this ?
 
Thanks in advance.


Replies:
Posted By: hilfy
Date Posted: 15 Nov 2010 at 9:27am

Crystal will only export to and read from .xls files - it will not work with .xlsx files.  AFAIK, there is no work-around although I expect that the next version of Crystal may read the new format.

-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: Zuzanna
Date Posted: 16 Nov 2010 at 3:56am
I wonder when they intend to do it. Thanks for letting me know.

Posted By: hilfy
Date Posted: 16 Nov 2010 at 5:57am
There is supposed to be a new version coming out early next year.  However, I have not heard for sure whether this part of it has been updated.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window