We help IT Professionals succeed at work.

Excel constantly "calculating" for United Kingdom Users but not US users

bhodge10
bhodge10 used Ask the Experts™
on
Hello, I've created a quote template that was originally used only by users here in the US. Now, users in the United Kingdom need to use it. The template uses macros and forms to navigate through the template. Users in the US do not have any problems, however users in the UK are having problems. Anytime they open up a form, code needs to run, however it is causing Excel to constantly "calculate" which renders the tool nearly useless. The users in the US are not experiencing this problem. The settings in Excel are all the same for all users as they all use the same VMWare remote desktop sessions. The UK users do have the UK keyboard settings. I am unaware of any other differences in their setup. Any reason why the UK users are stuck in the "calculation" mode when code is run even though the US users do not experience the problem when the same code is run?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
GrahamSkanRetired
Top Expert 2012

Commented:
You will need to interrupt it (Ctrl+Break) to find out what it is doing. If you need someone technically-minded to test it in the UK, I am willing to do so. I believe that 'rorya' is also in the UK.  'teylyn' is in New Zealand which is another English-speaking country that might have the same symptom.

If the file are too confidential to post here,  my email address is in my profile (obfuscated from email harvesters). That applies to most other experts.

Author

Commented:
Hello Graham,

Please check your email, I have sent you the file. Thank you very much.
GrahamSkanRetired
Top Expert 2012

Commented:
Hi Brad,

I misunderstood the problem. It isn't looping in VB code, but in formula calculation - somewhere and Excel formulae aren't my best subject.

It is a complex workbook with many sheets, so I would advise pinpointing the problem by removing some of the sheets to see if they make any difference.

If that doesn't help, I suggest using the 'Request attention' link to ask that question be re-promoted in the knowledge that it isn't VBA.

Author

Commented:
Hi Graham,

I think I've figured it out. On my userforms, I have a lot of text boxes that have a "ControlSource" along with the textbox having an "AfterUpdate" code. I think what is happening is for some reason the Date box in the Data sheet is causing all of these textboxes to fire because they are being triggered. Now I need to reconfigure the textboxes and rewrite some code. Does this seem accurate to you? Thanks again.
Commented:
Used my own solution - forced Europe users to use US date format.

Author

Commented:
No programming was needed, just changed user behavior.