Support topics - VT Final Accounts

#NAME appears in cells containing the SWITCH or TB custom functions/
Message about This workbook contains links

To resolve this issue:

• Close and then restart Excel
• Make sure the VT Function Library is ticked in the Add-Ins dialog in Excel
• Click on the New Accounts Workbook button and create a new dummy sole trader, partnership or company workbook. There is no need to save it
• Reopen the workbook that originally had the problem. It should now be OK
• If there is still a message about links and #NAME still appears in cells, see below:

For a small number of users the above procedure does not resolve the problem. In this case, you need to completely de-install VT Final Accounts and then re-install it from scratch:

• Choose the Re-install/Delete VT Final Accounts Toolbars command from the VT Final Accounts View menu of Excel
• In the Add-Ins dialog in Excel, untick the VT add-ins and click OK
• Close Excel
• Click Start, Search and then 'All files and folders'
• In the 'All or part of a file name' box type vt*.xla and then click Search
• Delete all the vt files found by clicking on them with the right mouse button and choosing Delete from the pop-up menu
• Restart Excel
• In the Add-Ins dialog in Excel, click on each of the VT add-ins. You will be asked to delete them. Choose Yes to each and then click OK to close the Add-Ins dialog
• Close Excel
• Re-install VT Final Accounts from the set up CD
• Restart Excel
• In the Add-Ins dialog in Excel, tick the VT add-ins and then click OK

We suspect that this problem may be caused by a faulty installation of Excel, so we also recommend re-installing Excel.