bhodge10
asked on
Excel constantly "calculating" for United Kingdom Users but not US users
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?
ASKER
Hello Graham,
Please check your email, I have sent you the file. Thank you very much.
Please check your email, I have sent you the file. Thank you very much.
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.
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.
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No programming was needed, just changed user behavior.
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.