<div>
go to formula tab and then click on caluclation option and select automatic
</div>


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

<div>
Thanks.<br />
<br />
And will this stay with the worksheet or will it change for every user?
</div>


Thanks.

And will this stay with the worksheet or will it change for every user?

<div>
Great!<br />
<br />
Thanks for your help.<br />
<br />
Cheers
</div>


<div>
you are welcome. i am glad i was able to help.
</div>


you are welcome. i am glad i was able to help.

<div>
I have just posted another one too!<br />
<br />
:)
</div>


<div>
<div class="content wysiwyg-content">
I have a vlookup which has stopped working until you hit save.<br />
<br />
How do i change it to automatically lookup or tab to the next cell?<br />
<br />
The workbook is shared and so I need to protect this setting.<br />
<br />
Cheers
</div>
</div>


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

MS Excel VLookup

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.