running Macro after launching Excel App

Posted on 2014-07-16
Last Modified: 2014-08-14
We have Excel Macro published on couple of XA 6.5 servers.
for some set of users post the launch of Excel, when they try to run the Macro it takes 30 minutes to load the data,
In my previous experience i have seen that sometime drive space or db dependency of app causes when space is consumed, or local printers being offline and getting mapped.
But now in this case none of the above.
Since some set of users are able to launch perfectly fine without any issue.....
some of the servers for the pub App are showing load 10,000 which is completely different issue and troubleshooting in this case but i didnot see any help from fixing those.

Any suggestions ?? for load 10,000 & for Macro running very slow with excel after the launch..... ??
Question by:xyz abc
    LVL 24

    Accepted Solution

    Is server configs are same? also same time check for other server load. Also need to know is the problematic shows always load as 10000 then try to restart the IMA service and check.

    Author Comment

    by:xyz abc

    I tried restarting IMA service no change. Yes the configurations are same.
    Its not the launching part of the App. Launching of App is perfectly fine. Its with the excel when user runs the macro....
    LVL 23

    Assisted Solution

    Hey arshmohd,

    I have seen these issues multiple times in our environment and normally a profile reset seems to do the trick, especially as you state that not all users are having issues.

    What i also did find (regarding the 10.000 load) is that Excel, by default, can and will use all CPU's for calculating formula's. If these macro's actually use formula's that might be your cause of the high load. Are you using any sort of performance managing tool like AppSense??

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Citrix XenDesktop 7.6 Citrix Policies Graphics
    How to install and configure Citrix XenApp 6.5 - Part 1. In this video tutorial we have explained step by step installation of Citrix XenApp 6.5 Server on Windows Server 2008 R2 is explained in this video. We have explained the difference between…
    This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

    755 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

    16 Experts available now in Live!

    Get 1:1 Help Now