?
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,899 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

765 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