Changing References to Sheets

There has been a fundamental change in the way which tabs are referred to. Any tab that containts a space in the name will now be referred to within ' '.

In the below example the first sheet is referred to as Sheet1 and the reference is shown in cell A4, whereas the second sheet has spaces within the name and the reference is shown in cell A5.

This will affect any existing reports and will cause a failure of any Excel formulae within your report.

Tab names

Either remove spaces from the tabs within the workbook or add the ' around the Excel Expression within the Connector. Don't forget to remove the = sign in the Expression Source.

Connector reference




On line via the Alchemex website

On site in NSW Sydney Region, the training is taylored to your needs, be it Alchemex or Excel.


report writing

Business Reports directly in Excel at the touch of a button using Alchemex.

All the major accounting packages are supported: MYOB, ABM, Sybiz, Sage packages (Handisoft, Accpac etc)

Excel & Alchemex Tips

Alchemex Tips & Tricks
There's often a little gem in the Alchemex Tips & tricks.

Excel Tips & Useful sites
Chandoo and Ozgrid are very useful......

© Orginal Template by Flipside Digital