This project has moved. For the latest updates, please go here.

Inserting formula problem

Jul 17, 2014 at 2:53 AM
I am trying to insert, using a loop, a formula that references another worksheet. Something like this:

" =$'ESPECIFICO - SIMULAÇÃO'.AG14/AD8 "

The problem is that, after saving and opening the my workbook, the formula does not work. And I found that if I just enter on the cell's formula, copy and past it again, without changing anything, then the formula will work.
Coordinator
Jul 17, 2014 at 2:59 AM
That's not a valid format. Your version of Excel is taking your input and based on your locale it converts it to what OpenXML expects.

Try something like: "='ESPECIFICO - SIMULAÇÃO'!AG14/AD8"
Jul 17, 2014 at 3:11 AM
Thanks, that worked! :)