Handling of converting cells to XFGetCell for column with member filter GetDataCell

Hi 

I would like to know if there is any settings or how would you deal with a cube view which has a member filter and in there a calculation for example F#None:UD4#AA5EX32011:Name(Cents):GetDataCell((Divide(CVC(Col1), CVC(Col3))*100). The user then exports the cube view to excel and converts each cell to an XFGetCells. See Screenshot 1. Once this is done the columns with the above formula return errors due to the calculation in that members. See Screenshot 2

 

 

Any advice or settings or best practice on how to deal with this?

Regards

Rehaan