Known issues in Affinity 3

The following items in Professional Affinity and Corporate Affinity are open and under investigation:

  • Certain Affinity functions may not always work properly when the system is used with Office/Excel 2007.  For example you might encounter any of the following: volume-weighted averages return #VALUE! rather than calculating; the PWTail function doesn't return statistics if you choose to have Affinity calculate the tail factor; graphics on certain Affinity toolbar buttons may not be visible (though the buttons still work); and certain multiple-tab Affinity templates may not append properly to a newly created model.

Solution:

A new release of Professional Affinity is available to resolve all known Excel 2007-specific issues.

Clients on maintenance can obtain the new release here.

 

 

  • When opening files in Office XP which were saved in previous versions of Microsoft Office, you may see "#Ref" in cells where formulas reference "PW" functions.

Solution:

  1. Start Affinity and select File | Activate Excel.
  2. Open the file that was saved in an older version of Microsoft Office.
  3. You should see the following Microsoft Excel message box: "The workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook?" Select "NO."
  4. Press Ctrl+Alt+F9. (#REF! should appear wherever there are "PW" functions.)
  5. In Excel, select Edit | Links.
  6. Under the "Source file" column, look for "PCRES.XLA" and select it. Press the "Change Source" button.
  7. Within the Change Links message box, browse to the Affinity root directory and select "PCRES.XLA."
  8. Click OK.

This will take care of the links problem. You may need to recalculate (F9) once again to see all of the links update.

 

 

  • When creating new multiple-tab files, using Affinity with Office XP, you may see "#Ref" in cells where formulas reference "PW" functions (this will occur only in certain Affinity templates).

Solution:

  1. Start Affinity and select File | Activate Excel.
  2. Go to Windows Explorer and find the Affinity root directory (most likely C:\AffPro32).
  3. Sort all of the files by “Type” and scroll down until you find files of Type “TPL File”. These files are the Affinity templates.
  4. Open all of these Professional Affinity templates by selecting them and then right-mouse clicking, choosing the “Open with…” option and choosing Microsoft Excel for Windows. (We recommend opening no more than 10 files at a time.)
  5. You should see the following Microsoft Excel message box: "The workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook?" Select "NO."
  6. Update the Affinity Links for all of the templates (using Affinity | Affinity Utilities | Update Affinity Links or select the Update Affinity Links button in Excel) for each group of Affinity files. Do not make any further changes to your files.
  7. Save them back to the same location (the Affinity root directory). You may get the following message:
    "xyz.tpl is a Microsoft Excel 5.0/95 Workbook. Do you want to overwrite it with the latest Excel Format?" Select Yes to update the files to the latest Excel format.

 

  • Using Affinity with Office XP, Excel can become unstable while creating multi-tab workbooks under certain situations.

Details:

  1. Using Affinity and Office XP, create a multiple tab file including any of the following Affinity templates:
         LDM (reported),
         BFM (reported),
         LDM with Standard Error (reported),
         LDM with Standard Error and Tests (reported), or
         the Modified Cape Cod (reported) in Office XP.
  2. Create an Affinity Summary Page (Affinity | Create Summary Page).  Select Append to current file: and click on Reserves under "Range Name to Summarize."
  3. On the Parameters Tab in Affinity, select any of the templates listed above, and click on Averages and then Edit. Select the "Tail Factor" tab and change the tail factor from "Specified Value" to "Calculated" and then click OK and Apply.
  4. When you go back into Excel and recalculate, Excel will no longer respond.  You will then need to go to Task manager and select End Task to manually shut down Excel.

Workaround:

If you choose to summarize "Reserves," change the tail factor to "Calculated" before you create a summary tab, and this process will work correctly.

 

As always, we welcome your feedback and suggestions.  Feel free to contact us.

 

 

Request more information about our solutions

P&C Insurance Software
Atlanta, Georgia, USA
Phone: 800 404.2276
  or      404 254.6752
Fax:     404 237.6984