[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Excel macros not executing in multi Citrix environment

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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

656 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