Focal Point
[SOLVED] Excel and Excel Plug In Conflicts

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8161098613

February 05, 2009, 05:16 AM
hammo1j
[SOLVED] Excel and Excel Plug In Conflicts
When excel is running in the plug in and I launch ordinary excel or vice versa I sometimes experience unpredictable behaviour such as the screen freezing.

Sometimes this is because a user needs to answer a prompt and if you alt-tab you eventually get to it.

Does anybody have a policy that cures this (other than advising users to use one at a time)?

Does setting excel with /e (existing) or /n (new window launch) resolve any of this.

Does applying later servicepacks of excel (we are on 2003) fix things?

This message has been edited. Last edited by: Kerry,



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
February 05, 2009, 05:20 AM
hammo1j
Something that may be of use.

If you kill excel via task manager you kill the plug ins too. So the plug in is not a separate program but uses excel.



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
February 05, 2009, 09:33 AM
Francis Mariani
Curious to understand what the Excel Pug In is...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 05, 2009, 10:13 AM
hammo1j
The 'plug in' is just excel running in the browser.

Within IE a plug in application is defined to be triggered for certain mime types in the HTML message the browser receives.

Similarly PDF is a plug in.



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
February 05, 2009, 11:47 AM
Nick
hammo1j,
We have experieced some issues when using Excel Templates. When the Excel template file is opened from WebFOCUS and the users Excel 2003 is not at the Service Pack 3 level, there were errors and strange behavior.

We have also instructed our users to not use the Excel browser plug-in but use 'real' Excel. This can be accomplished in Windows Explorer, select Tools, Folder Opetions, File Types. FInd XLS click the Advanced button and de-select "Browse in Same window". This forces Excel to open.

Hope this helps.


Dev- WF 7.68 on Windows Server 2003: DB2, SQL Server 2K, SQL Server 2005, SQL Server Anaysis Services 2005.
Test- WF 7.67 on Windows Server 2003: DB2, SQL Server 2K, SQL Server 2005, SQL Server Anaysis Services 2005.
Prod - Dev- WF 7.65 on Windows Server 2003: DB2, SQL Server 2K, SQL Server 2005, SQL Server Anaysis Services 2005
February 05, 2009, 11:56 AM
Robert Teo
We have also found that Excel 2003 and Excel 2007 have different behaviors under Vista. More salt into the wound!


A message from the darks side, there is!
February 12, 2009, 06:22 AM
hammo1j
Thanks Nick

Using excel 2003 SP3 cures a host of problems. I would suggest IBI officially lists this as a requirement as the behaviour generally gets blamed on webfocus rather than excel.

Regards

John



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo