Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2013-11-18
2
Medium Priority
?
1,926 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 23

Accepted Solution

by:
Ayman Bakr earned 1500 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part II
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

610 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