Template Alignment & Refreshing Issue

[pradeep.k.jagadeesan]

Hi,

I am working on an Excel Template, that refreshes whenever I am selecting a Customer. After I opened the template from the Application, when I select a customer for the first time, the template alignment and format has been changed than the format given. When I select the customer for the second time, it appeared as the given format.

Please anyone can help me out to resolve this. Thanks in advance.

Regards
Pradeep J

[Christopher Kernahan]

Are there any macros in the template? If it is set to autocalc, is it refreshing without a valid selection the first time? What exactly is changing in the format? Screenshots would help.