In one of my previous blog posts I demonstrated how to open a spreadsheet in manual mode. As you know, formulas do not refresh themselves on manual mode. I recently came across the keyboard shortcut for manually refreshing a spreadsheet.:
Click on "F9"
Click on "Fn+F9" if your keyboard has the Fn button
Moreover, it is also possible to record a macro to have this done automatically. Such a macro will specially come in handy when doing simulations such as the Monte Carlo simulation which I will discuss in one of my future blog posts.