If you want to continuously update your ipushpull pages from Excel, you may want to run your Excel session on a Virtual Private Server or a Virtual Desktop e.g. an Amazon WorkSpace. These services let you keep Excel running full-time without having it running on your own desktop PC.
You will need to install MS Excel and the ipushpull Excel add-in on the virtual machine. This is usually straightforward but you may need to modify the security policy on the VM first.
Installing on Amazon WorkSpaces
The default security policy on Amazon WorkSpaces does not allow you to run .MSI installers without elevated privileges. You will see an error message like this when you run the installer:
To change the machine policy to allow .MSI installers to be run from Windows Explorer, use the following steps:
- Click Start -> Run and enter gpedit.msc
- Click Local Computer Policy -> Computer Configuration -> Administrative Templates -> Windows Components -> Windows Installer.
- Select Disable Windows Installer and choose Edit policy setting:
- Click Enabled and choose Never from the Disable Windows Installer drop-down list:
- Click Apply
You might need to restart your Amazon WorkSpace for the changes to take effect, or you can run the following command: gpupdate /force
Now run the Excel add-in installer again.