Link to home
Start Free TrialLog in
Avatar of Stev0W
Stev0WFlag for United Kingdom of Great Britain and Northern Ireland

asked on

MS Excel VLookup

I have a vlookup which has stopped working until you hit save.

How do i change it to automatically lookup or tab to the next cell?

The workbook is shared and so I need to protect this setting.

Cheers
Avatar of Professor J
Professor J

go to formula tab and then click on caluclation option and select automatic
Avatar of Stev0W

ASKER

Thanks.

And will this stay with the worksheet or will it change for every user?
ASKER CERTIFIED SOLUTION
Avatar of Professor J
Professor J

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
Avatar of Stev0W

ASKER

Great!

Thanks for your help.

Cheers
you are welcome. i am glad i was able to help.
Avatar of Stev0W

ASKER

I have just posted another one too!

:)