Link to home
Start Free TrialLog in
Avatar of ADRIANA P
ADRIANA PFlag for United States of America

asked on

Adjust 3N File with NON-printing characters ONEDIGITTOP

29212673.xlsm

when added data to 3P sheet

it don't work !
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

it don't work !
That doesn't tell me what is wrong, but when make a change to the 3P sheet I get this. If it isn't correct please tell me what is wrong.User generated image
Avatar of ADRIANA P

ASKER

I change the data in E6 to E15

then add data in C24 to C35

i expect have the location  fo 3N  E24 to I35

but dont change 
Are the results in my picture correct?
Are the results in my picture correct? 

Yes !
when i change the values it don't work

i try to refresh with F2  shortcut

but it dont work
when i change the values it don't work
What values?
I will have always change 

E6 to E15

and   C24 to C35

 
This workbook and all of the other "map" workbooks that I've written for you all behave the same way. When you make a change to the bottom part (in this case C24 to C35), you will see results. If you change the top part (in this case E6 to E15) nothing will happen. So in other words if you change the top part and then you change the bottom part you will see results, but if you just change the top part or if you change the top part after you change the bottom part you will not see any change in the results.

Este libro de trabajo y todos los demás libros de trabajo de "mapas" que he escrito para usted se comportan de la misma manera. Cuando realice un cambio en la parte inferior (en este caso C24 a C35), verá resultados. Si cambia la parte superior (en este caso E6 a E15) no pasará nada. Entonces, en otras palabras, si cambia la parte superior y luego cambia la parte inferior, verá resultados, pero si simplemente cambia la parte superior o si cambia la parte superior después de cambiar la parte inferior, no verá ningún cambio en los resultados.
ok what will happens when i forget that so i do wrong

is not an way to reset it ?

becuse i try to get it to work but i fail
After you change the top part if you change one or more cells in the bottom part you will see results. But I will change this workbook so you don't need to do that.

Después de cambiar la parte superior, si cambia una o más celdas en la parte inferior, verá resultados. Pero cambiaré este libro de trabajo para que no tenga que hacer eso.
ok
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The very Best !!