Terminal server environments
Excel requires that XLS Add-ins be registered on a per user basis.
In Terminal Server environments our recommendation is to add the following line to all User's login scripts:
"C:\Program Files (x86)\Business Fitness\HowNow Smart Workpapers\adxregistrator.exe" /install="Workpapers.Next.Addin.dll" /privileges=user
NOTES On Previous Installations
- Previously the Add-in installed into C:\Program Files (x86)\Business Fitness. If you uninstall the Add-in first, the new Add-in will create and install into the new filepath C:\Program Files (x86)\Business Fitness\HowNow Smart Workpapers.
NOTES On Uninstalling
- Our recommendation is not to Uninstall this Add-in. However if your process requires this step, prior to TS uninstalling the Add-in needs to be deregistered for each user. This can be done by running the login script with a /uninstall on the end of the script. This will remove the Formula Add-in from the registration.
"C:\Program Files (x86)\Business Fitness\HowNow Smart Workpapers\adxregistrator.exe" /uninstall="Workpapers.Next.Addin.dll" /privileges=user
- Then you can safely uninstall the HowNow Smart Workpapers Add-in through Programs and Features.
After the installation has completed open Excel and confirm it has been installed correctly.
Select >File >Options >Add-ins. You should now see the following:
Full Uninstall
(when no longer using Smart Workpapers)
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)
------------------------------------
This will remove the XLL addin “HowNow Smart Workpapers Formulas” for all users
Final Uninstall (on Admin User):
Once you are sure all users have run the login script at least once, do the following:
1) Remove the login script
2) Perform a normal uninstall on the admin account by going to Control Panel / Uninstall Programs / Select ‘HowNow Smart Workpapers’ and uninstalling.
Please call the Business Fitness Support Team on 1300 333 424 if you have any questions or need assistance.
Other Notes
If a user has previously performed a Local User Installation, this will take priority over any subsequent installation for all users. The user will need to uninstall their normal copy of HowNow Smart Workpapers, which can be done through the normal Programs and Features menu of the Windows Control Panel, prior to registering the Terminal Server Installation.