It wasn't completely non-functioning, however it seemed to be having trouble picking up some keystrokes.
As far as I could tell these seemed to be random and randomly timed (roughly every 3-4th keystroke was being missed).
It is crucial though that the correct BIOS for your model is used however.
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.
To check if the USB device is faulty, simply unplug it (‘Eject’ it if it’s a USB storage device) and plug it into another computer. Sometimes, this can be fixed quite simply: 1) Unplug the power supply and charger plug from your laptop 2) Restart your laptop3) Connect your USB device to the laptop again4) Plug the power supply back in In order to save power, by default, Windows switches your USB controllers off when they’re not in use, and switches them back on again when they’re needed.
Unfortunately, sometimes this approach doesn’t work as intended, and Windows fails to switch your USB controllers on again.
Three attempts later and it was still adamant it wanted to be "Manual" and nothing else.
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 opened this spreadsheet, checked that this was still working and autoupdating with current installation of MS Excel and any new automatic office updates (which it did work with), and then just reopened the original spreadsheet. In my instance I was using a particular add-in called PI Datalink.So we ask you to proceed with caution, and discourage you from installing Cydia the manual way unless absolutely necessary.You should also backup your device, if you haven’t already, should anything go wrong.The good news is that saurik has quickly updated Cydia for i OS 8 and i OS 8.1, and made it available for manual download through his website.The Pangu team is expected to release an updated version of Pangu8, but if you can’t wait until then, here’s how to install Cydia the manual way.