Our previous Terminal Server instructions required you to install a Terminal Server version of the Add-in which is now called the 'Multi User' Add-in. Our new process is much simpler, if you wish to convert from the old Multi User installation to the new Terminal Server installation process, perform the following steps:


On Admin User:

Open Excel as Administrator

Go to ‘Excel’ / ‘Options’ / ‘Addins’ / ‘Manage – COM Addins’

Select ‘HowNow Smart Workpapers’ from the list and click ‘Remove’


This will remove the Terminal Server COM add-in “HowNow Smart Workpapers”  for all users


Login Script:

Next, modify the login script for each user to the following (note that the line: OfficeVersion=16.0 needs editing to match the version of Excel you are running)
------------------------------------
::**NOTE** Set Office version below to match what is installed
set OfficeVersion=16.0
::Remaining script will delete the appropriate key
set rkey=OPEN
set regvalue=reg query HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\%OfficeVersion%\Excel\Options /v %rkey%
set swptext="adxloader.Workpapers"
if not "x!regvalue:%swptext%=!"=="x%regvalue%" (reg delete HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\%OfficeVersion%\Excel\Options /v %rkey% /f)
set rkey=OPEN1
set regvalue=reg query HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\%OfficeVersion%\Excel\Options /v %rkey%
set swptext="adxloader.Workpapers"
if not "x!regvalue:%swptext%=!"=="x%regvalue%" (reg delete HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\%OfficeVersion%\Excel\Options /v %rkey% /f)
set rkey=OPEN2
set regvalue=reg query HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\%OfficeVersion%\Excel\Options /v %rkey%
set swptext="adxloader.Workpapers"
if not "x!regvalue:%swptext%=!"=="x%regvalue%" (reg delete HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\%OfficeVersion%\Excel\Options /v %rkey% /f)
set rkey=OPEN3
set regvalue=reg query HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\%OfficeVersion%\Excel\Options /v %rkey%
set swptext="adxloader.Workpapers"
if not "x!regvalue:%swptext%=!"=="x%regvalue%" (reg delete HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\%OfficeVersion%\Excel\Options /v %rkey% /f)
"C:\[mypath]\HowNow Smart Workpapers Setup.exe" /verysilent /preventdowngrade="true"
------------------------------------


This will remove the XLL addin “HowNow Smart Workpapers Formulas” for all users, and then it will install the Smart Workpapers Add-in for them.


Final Uninstall (on Admin User):

Once you are sure all users have run the login script at least once (this may take a few weeks), do the following:

1) Remove the ‘office uninstall’ lines of  the login script, so it should now just be:

"C:\[mypath]\HowNow Smart Workpapers Setup.exe" /verysilent /preventdowngrade="true"

2) Perform a normal uninstall on the admin account by going to Control Panel / Uninstall Programs / Select ‘HowNow Smart Workpapers’ and uninstalling.