Excel updated sells

Copper Contributor

when I added a vlookup formula and drag it to more sells the table not updated automatically.

only when i stand on one of the non updated sell and chose the formula from the formula bar and chose ENTER the sell updated.

4 Replies

Check your calculation options, should be Automatic

 

image.png

Thanks.
Did that solve it?

Yes, Thanks