Solved

Export from Navision 2013 to Excel gives error "HsTbar.xla" is in a different format (Citrix environment)

Posted on 2013-11-18
2
1,804 Views
Last Modified: 2013-11-24
Dear all

Users experience a strange behavior on our Citrix Xenapp 6.5 envoroment.

If a user is working in Navision 2013 and export a table to Excel 2010
 Navision 2013 to Excelthe user get the following message
Excel HsTbar errorbut the data in the sheet from Navision 2013 seems to be correct and also the Oracle "Smart View" ribbon is loaded. As I could read HsTbar.xla is for Oracle Smart View.

If Excel 2010 is already startet and the user exports the data from Navision no error message pops up. No error message appears on Excel 2010 startup.

The HKCU -> Software -> Microsoft -> Office -> 14 -> Excel -> Options = OPEN = "C:\Oracle\SmartView\Bin\HsTbar.xla" is correct.

Did anyone experienced the same issue? I did not found a solution on the internet.

HsTbar.xla is in the correct folder and I also gave for testing write permissions for the user.

Best regards
0
Comment
Question by:DangerExperts
2 Comments
 
LVL 23

Accepted Solution

by:
Ayman Bakr earned 500 total points
ID: 39662621
As you might have read on the Internet this message is a user-notification only. User notifications were introduced in office 2007 or later products just to warn against possible or potential incompatibilities or threats. As you can see, the warning is indecisive as it is not able to tell whether it is a corruption or threat - but it have detected that the content does not match with the .xla addin format.

The content here doesn't refer to the sheet in NAV, but rather refers to the Oracle Smart View .xla addin.

Now why this only happens when Excel is not started is really something I wouldn't really bother myself and waste my time as long as I trust the .xla ribbon and things are going on well when I click OK on the message.

But if I were to pursue it I would really open a case with Oracle who developed this .xla addin or look for an update to it.
0
 

Author Comment

by:DangerExperts
ID: 39673820
Hi Mutawadi

Thanks for your answer. Your advice with the user-notification in Office products pointed me in the right direction with one message pop up.

I try to get in touch with Oracle.

Have a nice day
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
equivalent of Enterprise 2008R2 OS edition in 2016 2 38
vmdk greater than 2TB 2 52
Export a GPO and import a GPO 3 42
Robocopy all drives in windows 2 19
Citrix policies are the most efficient method to configure and tune XenDesktop environments, allowing organizations to control connection, security and bandwidth settings based on various combinations of users, devices or connection types.  Citrix …
You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now