?
Solved

Excel macros not executing in multi Citrix environment

Posted on 2016-07-19
5
Medium Priority
?
390 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 J 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 J
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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

777 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