Project 2010 Visual Reports

A user of mine is using the Visual Reports function of Project 2010 with Excel 2010.  He is confident that the reports he creates should update dynamically when opened if the corresponding project file has been updated.  I cannot find any info online supporting this.  When he opens the excel book and tries to run an update, we always get a connection error.  The connection string points to a local cube file.

any help would be appreciated
DLBITAsked:
Who is Participating?
 
TommySzalapskiConnect With a Mentor Commented:
That's not how it's designed to work. The idea is that you create a Visual Report template and then you just run that from within Project and update the Excel file that way.
It's not supposed to be able to update from within Excel.

Even if you export to a cube, it's still the static data. You will need to re-export to the cube for the data to be refreshed, but this is easy to do with the report templates.
See this detailed MS article if you need more info.

http://office.microsoft.com/en-us/project-help/create-a-visual-report-HA010163709.aspx
0
 
TommySzalapskiCommented:
This one is good too. A bit less detail but simple and easy to follow.
http://msdn.microsoft.com/en-us/library/ms464131(office.12).aspx

These will walk you through how to make and refresh the reports.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.