Skip to Content
0

Analysis 2.5 for Excel overwriting Excel formula

Oct 20, 2017 at 09:58 AM

56

avatar image
Former Member

Hello

I try this on Analysis 2.5 :

- i add a column A with Column before..

- in this column i add the formula : = B2&C2

Formula AO changes to: =$B$2&$C$2 on all rows, i can't change them.

Any ideas ?

Kind regards,

Thierry

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Tammy Powlas
Oct 20, 2017 at 11:18 AM
0

Thierry - are you on the latest patch, SP2? If not would you patch and if that doesn't work please post some screen shots?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 20, 2017 at 01:20 PM
0

Hello Tammy

I think i'am in SP2, my version :

My test :

Regards,

Thierry


ao-25.png (23.4 kB)
ao25-sp2.png (17.9 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

No, Thierry, you are on the initial release, 00 - please patch up if you can...thanks!

0
avatar image
Former Member Oct 23, 2017 at 10:08 AM
0

up

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 24, 2017 at 07:56 AM
0

up

Share
10 |10000 characters needed characters left characters exceeded