Solved

Excel macros not executing in multi Citrix environment

Posted on 2016-07-19
5
154 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
  • 2
  • 2
5 Comments
 
LVL 25

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 25

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

#Citrix #Citrix Netscaler #HTTP Compression #Load Balance
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

776 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