Home | Support | VT Final Accounts topics

Support topics - VT Final Accounts

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

This topic refers to an installation problem with the VT Function Library add-in (Vtlib.xla). The VT Function Library supplies the SWITCH function, the TB function and functions used by VT's tax computation. The SWITCH function switches text between say Profit or Loss. The TB function returns amounts from the hidden trial balance obtained from VT Transaction+.

If the VT Function Library is not operating correctly, #NAME appears in the cells where the functions are used. #NAME can appear elsewhere in a workbook but this topic only covers problems with the VT Function Library.

When the VT Function Library is operating correctly the formula in a cell using one of its functions looks like this:

=SWITCH("Profit", "Loss", G19, I19)

When something is wrong it looks like this:

='C:\Program Files\Microsoft Office\OFFICE14\LIBRARY\VTLIB.XLA'!SWITCH("Profit", "Loss", G19, I19)

Please ensure that your add-ins are properly enabled

 If you still have #NAME? showing in your workbooks please go to your Add-ins tab in Excel and select VT Final Accounts>Help>About VT Final Accounts.

At the bottom of the dialog that comes up you will see the folder location for Excel and two of the VT Add-ins, if any of these are showing in red please let us know what they say ideally send a screenshot to support@vtsoftware.co.uk