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,848 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 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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Suggested Solutions

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…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…

737 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