Issue with CSV file

H

Howard Kaikow

I am programmatically creating a CSV file that has a list of formulae from a
workbook/worksheet (see example below).
Note that there are 5 records in the file, tho the text might wrap below in
your newsreader to appear to have more lines.
Double clicking on the CSV file causes Excel to issue #NAME? errors for the
records marked as BAD,

The records marked as "BAD" cause Excel to try to update the text due to the
included references to worksheets.
This occurs for a formula that begin with a "-" character. And, ditto for a
"+".
I can avoid the problem by sticking an apostrophe at the beginning of a
formula that begins with "-". or by multiplying by -1 at the end of the
formula.
I can avoid the problem by sticking an apostrophe at the beginning of a
formula that begins with "+". or by deleting the "+".

Is there a better solution?

"BAD","$I$11","-('123456789'!CurrentValue+'987654321'!CurrentValue+'00000'!C
urrentValue+Y17761492!CurrentValue+'123459876'!CurrentValue+Pizza!CurrentVal
ue)",
"GOOD","$I$12","('123456789'!CurrentValue+'987654321'!CurrentValue+'00000'!C
urrentValue+Y17761492!CurrentValue+'123459876'!CurrentValue+Pizza!CurrentVal
ue)",
"BAD","$I$13","-1*('123456789'!CurrentValue+'987654321'!CurrentValue+'00000'
!CurrentValue+Y17761492!CurrentValue+'123459876'!CurrentValue+Pizza!CurrentV
alue)",
"GOOD","$I$14","('123456789'!CurrentValue+'987654321'!CurrentValue+'00000'!C
urrentValue+Y17761492!CurrentValue+'123459876'!CurrentValue+Pizza!CurrentVal
ue)*(-1)",
"GOOD","$I$15","(-1)*('123456789'!CurrentValue+'987654321'!CurrentValue+'000
00'!CurrentValue+Y17761492!CurrentValue+'123459876'!CurrentValue+Pizza!Curre
ntValue)",
 
Top