Cyclodextrins (CDs) are cyclic oligosaccharides that emerged as industrial excipients in the early 1970s and are currently found in at least 130 marketed pharmaceutical products, in addition to numerous other consumer products. Although CDs have been the subject of close to 100,000 publications since their discovery, and although their structure and properties appear to be trivial, CDs are constantly surprising investigators by their unique physicochemical properties. In aqueous solutions, CDs are solubilizing complexing agents of poorly soluble drugs while they can also act as organic cosolvents like ethanol. CDs and their complexes self-assemble in aqueous solutions to form both nano- and microparticles. The nanoparticles have diameters that are well below the wavelength of visible light; thus, the solutions appear to be clear. However, the nanoparticles can result in erroneous conclusions and misinterpretations of experimental results. CDs can act as penetration enhancers, increasing drug permeation through lipophilic membranes, but they do so without affecting the membrane barrier. This review is an account of some of the unexpected results the authors have encountered during their studies of CDs as pharmaceutical excipients.