Skip to Content

Analysis for office references in a data source

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 2.5.100.71889

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers