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

asked on

adjust file to subtract in each digit for an 4 Digit from N F

User generated imageCal   2N 3n 4N  to  adjust 


I have a situation here with this file
always starts working well
but in a short time I can only see #VALUE!
all the time and does not get out of that situation

it does not let me see the values that I need to see

the same thing happens in the 3 sheets
2N 3N 4N

so he won't let me work

Some button is necessary to help this not happen
I mean with a code that helps?

Avatar of Michael Pfister
Michael Pfister
Flag of Germany image

I assume the sheet is set to "manually calculate". Go to ribbon "Formula" and click "Calculate sheet" to start it manually, took a while on my machine (~1 min).
Avatar of ADRIANA P


Michael Pfister 

I set it to manual from the get-go but it doesn't work either...

that is, it works a little bit well but then it doesn't let me see the   values
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

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