Solved

Excel macros not executing in multi Citrix environment

Posted on 2016-07-19
5
299 Views
Last Modified: 2016-07-27
We have an Excel workbook (Excel 2013) on a Citrix XenApp 6.5 server (server A), which has a lot of macros.

When we access from a PC running the latest Citrix receiver we have no problems.  The macros take about 1.5 mins to execute.

However, some of our users have an internal Citrix environment (server B) from which they access the server A.  They access Server B using Citrix receiver 4.2.0.10

Intermittently these users (Server B to Server A connection) experience an issue where the macros in the workbook stop working (or possibly work so slowly that after several hours there is no activity).

I know there is a similar issue when XenApp 6.5 is accessed directly from a pre version 3.2 Citrix Receiver.

Has anyone experienced similar or can point us in the right direction

TIA

Martyn
0
Comment
Question by:isense
[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
  • 2
5 Comments
 
LVL 26

Accepted Solution

by:
Tony Johncock earned 0 total points
ID: 41719192
Hi Martyn

I am not aware of any Excel / Macro issues with the 4.2 Receiver. Is there any way you could upgrade one server to the latest version to see if it cures the problem?

In the interim you could try server-to-server access via RDP for a test user rather than Receiver as this would rule out Receiver being the problem.
0
 
LVL 1

Author Comment

by:isense
ID: 41724220
Tony

Thanks for your response.

It turns out that server A has a version 3 receiver which it uses to talk to server A, even though the end user is using version 4.2.0.10

We are now in the process of updating server B
0
 
LVL 26

Expert Comment

by:Tony Johncock
ID: 41727408
Hang on...so where I specifically said..."Is there any way you could upgrade one server to the latest version to see if it cures the problem?" and this turned out to be the issues, you still feel the need to not award me points?
0
 
LVL 1

Author Comment

by:isense
ID: 41730939
Problem found
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

724 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