This project has moved and is read-only. For the latest updates, please go here.

Inserting formula problem

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


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.
Jul 17, 2014 at 3: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 4:11 AM
Thanks, that worked! :)