MS Excel - VLOOKUP result is not calculated automatically

[John_P]

I have an application that generates a file that include VLOOKUP formulas, but the result is not calculated automatically. I need to manually press F2 + Enter to have the result calculated.


Facts:
- I already set: Formulas > Calculation Options > Automatic
- B6:B17 and B19:B26 have the "General" format
- B28:30 and B32:34 have the "Numeric" format


The final idea is to print the text only, not the number zero


Here is a copy from the file:
https://drive.google.com/drive/folders/1ai_bHPXqfyZSQeSfUN8XcEIJz4fX7gqh?usp=sharing

 

[Special-K99]

Ctrl-Alt-F9 solves this in a flash for all values though I'm not sure what is causing this.

 

[John_P]

Ctrl-Alt-F9 solves this in a flash for all values though I'm not sure what is causing this.

It worked, but is it possible to perform this action automatically right after the file is opened? I don't want the final user from this file to always be pressing Ctrl-Alt-F9.
Thanks!

 

[Special-K99]

No idea, that probably requires a VBA solution which I don't know a great deal about.