PopTools logo

Bugs and FAQ

This page documents known bugs and frequently asked questions about the current version of PopTools. Earlier bugs are documented on the Update History page.

Please send bug reports to poptools@csiro.au.

PopTools menu item remains after uninstallation

Right click on the Excel toolbar. Choose “customize”, and then drag the PopTools menu item from the toolbar.

Analysis of large ranges produces a #VALUE result

PopTools returns results to Excel via VBA which is limited to range sizes of 5461 elements for Excel 2000 and below. If the output is larger than this, no result will be returned. For some routines, if the output is larger than 5461 elements it is copied to the clipboard so that you can then paste the results into your worksheet. Excel XP and above do not have this limitation.

Cell with PopTools formulas show #VALUE

This is usually caused when a spreadsheet has been opened on a new computer. If PopTools is installed in a different location on the computer that has opened the file, Excel may look for PopTools in the wrong location. To fix the spreadsheet, choose ‘Update PopTools Links’ from the PopTools menu system while the spreadsheet is open. If that fails, try the ‘Fix references’ button.

Help file is out of date

Yes. The help file is out of date. A new help file can be purchased from the author’s home page.

Footer image - matrix analysis