If you're experiencing problem #4, here are some possible scenarios as to why you did not receive the "Order Confirmation" email: If for any reason you did not receive your "Order Confirmation" email, please call our vendor to obtain your Spy Hunter account information.
However, for some reason, the value calculated by the formula does not update automatically. We already had the calculation options set to automatic and didn't know why values weren't updating.
I am having to click on the formula bar, then I have to click enter for the formula cell to do its thing. F9 and Shift F9 didn't help and left the values the same.
Copy the contents of the spreadsheet to a new one, and deleted the old one (it wasn't a particularly important spreadsheet, thankfully), and everything was fine.
I can only assume that somehow the file had become corrupted.
To do this, you can use Device Manager on Windows, System Profiler on a Mac or the /lspci or /lsusb commands on Linux.