Hello,

We have attached a pivot table in Excel 2007 to our database.

In Excel I have then converted the pivot table to formulas so that I can build a report and then have the system fill the report in.

I have a simple report looking at revenue and an Example of the formula being used is:

CUBEVALUE("\nltdb MatrixCubes MatrixCube",$A$1,$B3,$A$5)

Where $A$5 is referring to is a dept name referred to in the formula as:

=CUBEMEMBER("\nltdb MatrixCubes MatrixCube2","[Job].[By Booking Office].[Booking Office].&[Stg Ltd. UK].&[Green Team]","Green Team")

But what you see in Excel is Green Team

If I copy and paste special values this field the first formula still returns the revenue value, however if I type in Green Team it returns an #N/A

Any ideas why it would do this and how to rectify the problem?

Thanks