Skip to Content

Analysis for office references in a data source

Oct 30, 2017 at 12:55 PM


avatar image

Hi experts.

I need to reference a data cell from one data source to a column formula of another. I Want to fix that cell. In a normal excel the formula would be like this: D4/hoja1!$A$1 but here in AFO the dollar references changes. I see thet when it puts dollars means that will go down and when not, it fix the cell. But in this case if I remove the dollars, AFO put them again. Could someone explain me or tell me a place to see how AFO References work ?

cause I have one datasource with just one line and I want to refer to that cell and not the ones it has under it when i drag.

The excel version that i'm using is 2016 and the AFO version is

10 |10000 characters needed characters left characters exceeded

Please share version of Excel you are using and version of Analysis Office

* Please Login or Register to Answer, Follow or Comment.

0 Answers