I have developed a spreadsheet in Excel 2003 which attaches to an analysis
services cube, using the analysis services add-in function "cubecellvalue"
plus appropriate mdx statements to build the sheet in the format required.

However in Excel 2007 this only works if I alter the sheet to use the
built-in function "cubevalue", which then does not work in Excel 2003.

My problem is that I have users who need to share spreadsheets, and they are
using a mixture of versions. Do you think it is possible for me to create
and distribute a function of my own called "cubevalue" in Excel 2003 which
would then make the sheets compatible with Excel 2007 ? Or does Microsoft
have a compatibility aid that I am not aware of which would avoid this
problem ?