I'm having difficulties with my VT, or should I say Excel. I have lost my add ins and have tried using the options bar etc to reinstate them, but keep coming up with with an error saying that there is a problem with excel and VT add ins. Have been on to VT themselves today, but they are unable to resolve it for me. I've uninstalled microsoft office and uploaded it again, but still not working. Without having to buy a new PC, which is looking a distinct possibility, does anyone have any ideas on how to resolve this please.
what version of Excel and Windows are you on Debbie?
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
Very easy fix for me on that one, I just deleted Sage to make VT start working again.
In the manage add-ins screen accessed via the Excel options screen the following should all have been ticked :
- VT Data Export - VT Final Accounts - VT Function Library
You may need to close and reopen Excel for the changes to take effect.
Is the Analysis Toolpak enabled in your add in's? if so untick it as that is known to cause issues with VT.... In fact, untick all add in's except for the three VT entries shown above and then restart Excel.
You talk of reinstalling Excel but your issue is more likely to be a need to reinstall VT (you should be able to simply redownload from their site).
The questions to ask yourself are :
When did it stop working? What has been updated / installed since you last used the software?
Hope that you get your probelms resolved. When you do let us know what you needed to do to fix it.
-- Edited by Shamus on Wednesday 20th of April 2016 11:40:15 PM
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
Hi shaun,
Thanks for your reply. Sorry, after trying to sort this for most of yesterday, I'd had enough last night so called it a day and resorted to wine
I've reinstalled vt and have checked the add in boxes as you've suggested, but it still doesn't solve the problem. I'm using excel 2010 and windows 10. All was ok. Only thing I have done differently was I ran a system scan at the weekend. I use avg. It found 2 threats which it removed. Not sure if that could be the problem. However, I've tried disabling avg to see if that would resolve the issue and it doesn't. I've run out of ideas. The guy from vt yesterday took remote control of my pc and he was unable to work out the problem. I'm going to try a different computer today and download vt on to it. Other than that I have no idea what to do.
Hi Debbie
I'm a complete Vt novice and a technophobe! BUT, have you tried a system restore to before you ran AVG? Then perhaps try say Malware and see if this fixes the problem? This simple action fixed a major problem for me about 18months ago, although it wasn't by any means Vt related.
__________________
Joanne
Winner of Bookkeeper of the Year 2015, 2016 & 2017
Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.
You should check out answers with reference to the legal position
Considering that you have reinstalled VT Accounts, it seems to me that either a windows or Excel component that is needed by VT is missing. generally that means that its a windows component that Excel cannot find as MS Office products share the API's supplied with the operating system.
The issue could be a Windows update replacing a legacy driver and now VT is having issues, but VT I suspect is the symptom, not the problem.
Hopefully this is not AVG deciding that a legacy windows component used by VT (via Excel) is not needed and its existence on the system poses a security threat so havs been removed (I know of cases where Norton has done that).
Unfortunately, having some idea where the issue lies and fixing it are somewhat different as you need to know what is missing in order to restore it.
Also, the issue is not necessarily with AVG but could be a Windows update that wasn't particularly well considered.
Two approaches I would go for here. First would be a system restore back to a point where you knew that VT was working. The other would be to take a look at your menu bar close to where the date and time is dislayed. Is there a flag there? Those are windows messages and will include an entry that says "Check for solutions for unreported problems" against that there will be a link that says "view problems to report" where you should be able to find more details on the issue that you have been having.
And that for me is where the wheels come off the bus as I don't want you to end up in a worse position that you are in at the moment by ending up corrupting Windows.
Once you have found in that list the actual problem which will be a lot more detailed than the message you got from Excel then it really needs to be someone with a lot more Windows based knowledge such as Vince to fields this.
As mentioned above, I think that the issue showing with VT isn't actually the real issue.
Sorry that this is just suggestions rather than an answer, I know how frustrating these things can be.
Shaun.
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
Let us know how you get on Debbie. Must admit whilst posting earlier my thoughts were a Windows 10 issue. If Shaun's suggestions fail, which fingers crossed they dont, might be worth posting on the VT dedicated part of Accounting Web. Whilst I know the VT team will answer on there and they werent able to help thus far, there are a lot of others who might have had the same problem who can help. Let me know if you cant find it and I will dig out the link.
__________________
Joanne
Winner of Bookkeeper of the Year 2015, 2016 & 2017
Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.
You should check out answers with reference to the legal position
Go back to AVG and investigate the two threats you said it removed. That would be my bet.
It *should* log these, and the front end should provide away for you to see the log of what it has removed - and, in the event it's messed up, there should be an option to restore what it has broken/removed. (I don't use AVG, but if it doesn't provide such functionality, it's broken.)
(Do be careful, though: Don't just restore on the basis that it might solve the problem: Look at what you are restoring, and contact VT and ask if the items listed are needed by their software.)
As an aside, I'm having interesting issues myself here with Firefox - which is seemingly forgetting certain settings. Using a Firefox 'refresh' I've got those settings working... and now other settings are being forgotten. The timing of this starting coincides with my most recent review and installation of Windows updates. :/
I'll be restoring to just before those updates this weekend, then I'll install them one at a time to see what happens.
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
Jay wrote:Shaun is spot on, if it was working at some time and you have a restore point prior to that, then restore to the earlier point.
Hi Jay,
to be fair Joanne beat me to that one.
I started my reply, did the school run then finished it off when I returned.
Obviously in the interim Joanne sped down the M6, broke into my house, noted down the stuff on my screen and then without an incling of remorse plaigerised it as her own... Whats the world coming to when you can't trust a fellow banker.
Lol.
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
Hi all. Many thanks for all your help. So far however no luck. I've tried everything suggested and still not resolved the problem. I've tried vt on another computer and it runs fine so am guessing it's a trip out computer shopping. Think the old one will then be wiped and start afresh. Think there will be a few hours spend transferring data. Might have to eat some of those cakes while I'm doing it. Again thanks for your help
Debbie