1

Topic: formulas in EXCEL

Problem essence: wrote  formulas in EXCEL (VBA), all worked normally, sent to the customer. Through any time writes, a pier formulas are not considered. I look its file and really are not considered. I open an initiating file which sent to it, there all , works like clock-work. colleagues what there can be a problem and how it is possible to correct?

2

Re: formulas in EXCEL

At the customer
Specify the version
Specify language
Specify language of OS and regional settings
Compare to the

3

Re: formulas in EXCEL

kos20 wrote:

a problem Essence: wrote  formulas in EXCEL (VBA), all worked normally, sent to the customer. Through any time writes, a pier formulas are not considered. I look its file and really are not considered. I open an initiating file which sent to it, there all , works like clock-work. colleagues what there can be a problem and how it is possible to correct?

This business - the most normal.  to check prematurely. Early still.
100 %, and with odds on 150 % - all as usual:
At you considers - because you Excel - knows about written you, on your computer on vba formulas.
You on the Excel wrote the formulas.
And at the customer - Excel simply does not know, where them to take.
There is no at it a code of your formulas.
Therefore Excel their customer does not know and cannot consider.
And it is all that you "sent" something to someone.
Instead of to the computer of the customer pinches  and pens directly to it Excel code to write.
You sent a baby's dummy to it.
The book with calls of formulas not existing at the customer.
Now all the same it is necessary to you pinches to the customer , and pens the code vba on the computer of the customer to write.
Well, still there is a variant to open a new topic with a question - how to "send in addition and"install"your creation of formulas to the customer.
That it Excel learned about yours formulas.
Somehow so.

4

Re: formulas in EXCEL

booby;
They worked for it month. It in adjustments EXCEL. Formulas are sewn up in ! More shortly, yesterday took a formula source code work, checked up.... Again opened a file from the customer - formulas earned... Somehow strange... Those somewhere, at some instant time glorked adjustments EXCEl/Checked up standard type recalculation automatic - all inclusive... (

5

Re: formulas in EXCEL

Safety - there changed nothing? Updates of a name Microsoft were put - whether there was a problem right after it?

6

Re: formulas in EXCEL

formulas ? Applcation. Volatile in them is present at the first line of a vba-code?
If the standard do not consider, m. At the customer in   disconnected in Parameters of adjustment autorecalculation of formulas?

7

Re: formulas in EXCEL

kos20 wrote:

booby;
They worked for it month. It in adjustments EXCEL. Formulas are sewn up in ! More shortly, yesterday took a formula source code work, checked up.... Again opened a file from the customer - formulas earned... Somehow strange... Those somewhere, at some instant time glorked adjustments EXCEl/Checked up standard type recalculation automatic - all inclusive... (

If directly in  - that the question can be to adjustments safety vba and-or to signature presence on the code
And-or to a file location.
At the confused customer the superstructure can appear more preferably the code in .
Though, strongly confused, it all the same does not help.
But a subject with superstructures to twist before stable rise from a label anchored to a start script it is possible.
But it for customers of special, exceptional stupidity.
Deserved deserved reliably certified diminished responsibility of such personal decision.