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 

29225496b.xlsm


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

ASKER

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
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
Great Job !
Best Expert !