I've come across an issue in which Microsoft Excel 2010 in which you can't change printer from the default printer to another printer
This is a problem with Excel being a bit lost reading a particular registry key from the comptuer. The problem is not with Excel itself but with the compter, you can test this by trying to change the default printer, if it gives you the error message: "Operation could not be completed (error 0x00000709). Double check the printer name and make sure that the printer is connected to the network", then you know is something wrong with the computer
Fix: Delete old printers from the registry key
To fix this problem, logon as an administrator to the computer, open regedit and navigate to the registry key: "HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Devices". You will notice most likely a massive amount of old printers:
To support this site click and explore the advert - Thank you!
Start deleting the printers that are not valid anymore, most likely the local ones, and then give a nice reboot to the computer
After the reboot, if you are able to change the default printer without having the above error 0x0000709, Excel will work
See below the default printer is different: