Skip to Content
0
Former Member
Mar 05, 2009 at 10:10 PM

Refresh Live Office" option missing

65 Views

Hi,

_Issue:_ "Refresh Live Office" option missing when we try to import the excel source file in to xcelsius

Technical Environment: BOXI R2 SP1, Xcelsius 4.5, Office 2003 (SP1)

Additional details: We recently moved all our dashboards from Testing environment to Production (both have the same technical environment). All the excel files are remapped to the production database and we are able to refresh them within excel. When these excel files are imported in the .xlf file, the "Refresh Live office" option (in the excel model import window where you can see the other 3 options "Refresh Data Sources", "Clear Data sources","Refresh Spreadsheet Format") is missing.

And the live office connector doesnt show any view's associated with the imported excel model where as the source file contains 4 views and all of them are able to refresh.

Troubleshooting done:

  • Cleared all the existing data sources and then reloaded the excel file - NO GO

  • Created a new webi report and imported that to a new excel sheet and then tried to import to a new xcelsius file --- NO GO

  • Upgraded the Office with Microsoft Office 2003 sp1 - No GO

  • Uninstalled and resinstalled the Live office connector - No Go

  • Applied the hotfix to the Xcelsius 4.5 - No Go

  • Upgraded the Microsoft office with SP1

  • Tried importing the excel file to xcelsius 2008 (I have both installed on my machine but we use 4.5 for this specific client) - Still the option for Live Office is not visible

I am not sure what's the issue here as all the dashboards in testing are working absolutely fine. Please suggest on how do I proceed ahead as we have a production roll out in a week.

Thanks in advane.

Regards,

Pavan