Vista trend log links in reports are not updating after upgrading Vista.

Issue

Vista trend log links in reports are not updating after upgrading Vista.

Product Line

TAC Vista

Environment

Tac Vista 3.2.1 - 5.1.6

Excel 2000 - Excel 2010

Cause

Compatibility issues between the different versions of Excel mean that it is not possible to upgrade the Vista version and the Excel version simultaneously. This is especially applicable when upgrading an older system (3.2.X) which runs on an older operating system with an older version of Excel.

Resolution

Below is a table with a suggested upgrade plan taking into account the introduction of the SQL logdatabase in Vista 4.5.0 and Vista/Excel/OS compatibility:

Vista Version Excel Version SQL to Vista version Excel version SQL Comments
Upgrade Plan TAC Vista
3.2.1 2000 -   3.2.1 2000 SP1 - Excel upgrade
3.2.1 2000 SP1 -   3.3.3 2000 SP1 - Vista upgrade
3.3.3 2000 SP1 -   4.0.1 2000 SP1 - Vista upgrade
4.0.1 2000 SP1 -   4.2.5 2000 SP1 - Vista upgrade
4.2.5 2000 SP1 -   4.5.0 2000 SP1 MSDE Vista/SQL upgrade
4.5.0 2000 SP1 MSDE   5.0.3 2000 SP1 2005 Vista/SQL upgrade
5.0.3 2000 SP1 2005   5.0.3 2007 2005 Excel upgrade
5.0.3 2007 2005   5.1.6 2007 2005 Vista upgrade