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