Skip to Content
0

Problems with a Excel formular in a AfO column

Feb 16, 2017 at 02:22 PM

82

avatar image
Former Member

Hello,

we use AfO 2.3 with Excel 2010. We want calculate a new result in a AfO column with a Excel formular. This calculation works correctly in one row (see File attached to row 4). When copying to several lines, a formula element is converted to a fixed reference ($D$4) (marked in yellow). How can this permanent relationship be exempted? The correct formula is in the green marked column beside it.

Thanks for tips and Solutions.

Heiko Stranghoenerafo-formular.jpg

afo-formular.jpg (228.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Feb 16, 2017 at 03:49 PM
0

Heiko - I can't replicate this in Analysis Office 2.4.1 with Excel 2016. Perhaps you can upgrade to 2.4.1 and try it again?

Share
10 |10000 characters needed characters left characters exceeded
Stephen Hobbs Feb 17, 2017 at 01:54 PM
0

I have noticed that the Excel formula integration has changed and is improved in 2.4 over 2.3...

Share
10 |10000 characters needed characters left characters exceeded