Tuesday, October 12, 2010 2:21 PM
I am using Project Standard 2010 and Excel 2003 sp3 (don't have Visio at all). When I try to run visual reports I get an Unknown error. I cannot save a .cub either. Get the same error.
Tuesday, October 12, 2010 4:08 PMModerator
Without Visio 2007 or better installed, you cannot run any of the Visio reports. However, you should be able to use the Excel reports. Have you tried running a repair on Excel? Try that first and see if it makes a difference.
Gary Chefetz, MCITP, MCP, MVP msProjectExperts
Project and Project ServerFAQs
Project Server Help BLOG
Tuesday, October 12, 2010 6:50 PM
Ran repair on Excel and am still seeing the same behavior. Any other recommendations?
Tuesday, October 12, 2010 7:11 PMModeratorDkourtis --It was my understanding when Microsoft released Microsoft Project 2010 that users can create Excel Visual Reports using Excel 2003, 2007, or 2010. However, at a client site last week, most of my students in class had the 2003 version of Excel, while a few of them had the 2007 version. None of the Excel 2003 users were able to create an Excel Visual Report, while all of the Excel 2007 users were able to do this.Based on this one set of users, I suspect that you cannot create an Excel Visual Report using Excel 2003. Since Microsoft staff now peruse this user forum on a pretty regular basis, I would gladly ask them to comment. Hope this helps.
Tuesday, October 12, 2010 11:10 PMI am also unable to create a visual report with Project 2010. I have Excel 2007. While attempting to create a visual report, or saving a cube for that matter, I get an Unknown Error.
Thursday, October 14, 2010 4:43 AMModerator
Per the question around Project 2010 Visual Reports working with Excel 2003, it looks like there is a setup issue. Project 2010 installs OLAP10 but for some reason when Excel 2003 is there, it isn't getting installed correctly.
To workaround this issue, you need to manually install the Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider. You can get that through this link - http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=b33d2c78-1059-4ce2-b80d-2343c099bcb4
Rod - not sure what is causing your issue. Let me investigate.
- Marked As Answer by Dkourtis Thursday, October 14, 2010 4:29 PM
Thursday, October 14, 2010 3:47 PMModerator
Thursday, March 03, 2011 2:23 AM
I have this same issue. I did install Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider but I still receive this error for all visual reports. I currently use MSProject 2010 and I have Excel 2010 as well. Has there been any word on another workaround? I actually can see the reports through Reports/Custom...it goes straight to print screen and through print preview I can see them there, which is odd but I was able to get my assignments done for my class that way at least.
Thanks so much,
Tuesday, June 14, 2011 11:34 AM
For the first time, I'm using Project 2010 for a "real" project, along with Excel 2010. Previously used Project 2007. Looking like I have to go back to it.
Having real trouble making Visual Reports work in Project 2010 with Office 2010.
Have only Office 2010 components on this machine. Was getting the dreaded "unknown" error when trying todo a Cash Flow to Excel. Did a "repair" on Project 2010 and Office 2010. Now Project tells me the source MPP file is "read only" (it is not) and asks me if I want to save a copy? If I say "Yes", it gives me a save dialog box then Project cancels. If i say "no", it also gives me a save dialog box and then crashes. The "Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider" above appears to be 64 bit only (and I'm guessing the "repair" should have repaired.
(I was told by the PrimaVera guys working for the main project (I'm part of the Owner's team), that Project doesn't work. They cold be right.)
Friday, May 04, 2012 1:38 AMI am using Project 2010 and Excel 2007 and experience this same error when I set Select level of usage data to include in the report: to Weeks. However, it works for every other setting. Of course, the resulting PivotTable when using the Days setting includes a Week grouping level. I did not install the OLE DB Provider. However, I have repaired Project, but I am not sure it was necessary since the Weeks setting failed before doing so, and the Months setting worked.
- Edited by MikeMoses Saturday, May 05, 2012 8:38 PM