[Last Call] Learn how to a build a cloud-first strategyRegister Now


running Macro after launching Excel App

Posted on 2014-07-16
Medium Priority
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 26

Accepted Solution

Sekar Chinnakannu earned 500 total points
ID: 40201095
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
ID: 40201926

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

rhandels earned 500 total points
ID: 40248194
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

#Citrix #XenApp #Citrix Scout #Citrix Insight Services #Microsoft VMMAP #Microsoft ADEXPLORE #Microsoft RAMMAP #Microsoft TCPVIEW #Microsoft AUTORUNS #Microsoft PROCESS EXPLORER #Microsoft PROCESS MONITOR
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

834 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