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 firstname.lastname@example.org.
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.