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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

867 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

20 Experts available now in Live!

Get 1:1 Help Now