Reproducing the Issue
- Open Xcelsius.
- Import excel sheet with live office connection in it.
- The live Office Options for eg:- Refresh and Go To are disabled.
Product version:-Xcelsius 2008 sp1
Operating System:- Windows XP
Microsoft Office Version:- Microsoft office 2003, Microsoft Office 2007
The issue is identified as a bug- ADAPT01074967 and no fix is released till date.
As a workaround for the issue, develop and refresh all the Live Office objects outside Xcelsius i.e in the Excel sheet and then import the same Excel sheet.
Live Office options greyed out refresh go to , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Bug Filed