DBR() error when pointing to a different sheet

[TheMichael]

Hey guys,

I've got a weird problem that I don't quite understand.

When doing a dynamic slice on a view into excel I get my list of dimensions first (About 40 dimensions) with the data following after that. If I cut the section with all my dimensions and move it say from column B to column C the formula's change with it and hitting F9 still works.

Now, when I cut the cells referring to the dimensions and paste it in a new sheet the formula's still change with it (For example "A1" might become "Sheet2!A1"), but I get KEY_ERR's.

Any idea why this happens ?

This is the first time I've actually got a cube with this many dimensions (Normally it's less than 20). Could this have something to do with it ?

[lotsaram]

The problem is more likely to be that you have done a dynamic slice rather than a static slice. I have always avoided dynamic slices like the plague but I am pretty sure that they require the row, column and title headings to all be on the same sheet as the data/view range.