Updating an old mac
What I found to be the problem was the formula and the fact that I surrounded numbers with quotes.
Would you like to answer one of these unanswered questions instead?"Icons" views have a direct link to Device Manager, as does "Classic View" on Windows Vista only.Windows XP and earlier: Click , click on the Hardware tab, then on the "Device Manager" button on the Device Manager panel.I changed the setting as indicated above; but the auto-recalculate still did not work, and upon rechecking the "Calculation" option, found it had reset itself back to "Manual" all by itself.Three attempts later and it was still adamant it wanted to be "Manual" and nothing else.Any drivers they offer will usually be generic drivers not matched to your particular motherboard. Note that basic plug 'n' play USB sound devices without a choice of inputs (like a USB microphone or a USB turntable or cassette deck) generally use the operating system's USB Audio Class drivers.
If such a device is malfunctioning and the manufacturer does not offer special drivers, examine the USB cable and connections, or look in the device's or the operating system's control panels for issues with the device or with the Universal Serial Bus controllers. Windows users can try updating their drivers via Device Manager in the first instance, before looking for drivers on the internet.
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.
In Settings I had to change Automatic Update command to Full Calculate and then back again.
Once the original setting had been restored, the add-in ran as normal.
Once you have the necessary information about your sound device, you can normally obtain appropriate updated drivers specific to your hardware from the internet.