Limitations of XLSior
XLSior, like most things, has its limitations.
The testing tool can only test calculations performed by worksheet functions; it can't test calculations performed by macros (other than user-defined functions) for calculations. It can't substitute in ranges that have array formulae. Finally, it can't be used to test:
- Pivot tables
- Solver
- Goal seek
- Scenarios
The autodocumentation tool can't get full information about external links. See the help for details.
Many of the commands will not work with shared workbooks. Some of them will not work with workbooks whose structure is protected.