Powerpivot convert to formula trouble

[evelez]

I converted a pivot table into formula (kept one copy of the pivot table as backup), but when I update or refresh all, it does not display new rows (although the original pivot do) why, how do I get it to work?

 

[gorem]

what is your formula?

 

[evelez]

what is your formula?

=CUBEMEMBER("ThisWorkbookDataModel","[CLIENTES].[REFERIDO].&[Leticia Sanchez]")


=CUBEMEMBER("ThisWorkbookDataModel",{"[CLIENTES].[REFERIDO].&[Leticia Sanchez]","[PAGOS].[#MOV].&[1619]"})

=CUBEMEMBER("ThisWorkbookDataModel",{"[CLIENTES].[REFERIDO].&[Leticia Sanchez]","[PAGOS].[#MOV].&[1619]","[PAGOS].[FECHA].&[2014-09-01T00:00:00]"})

=CUBEMEMBER("ThisWorkbookDataModel",{"[CLIENTES].[REFERIDO].&[Leticia Sanchez]","[PAGOS].[#MOV].&[1619]","[PAGOS].[FECHA].&[2014-09-01T00:00:00]",

=CUBEMEMBER("ThisWorkbookDataModel",{"[CLIENTES].[REFERIDO].&[Leticia Sanchez]","[PAGOS].[#MOV].&[1619]","[PAGOS].[FECHA].&[2014-09-01T00:00:00]",

=CUBEMEMBER("ThisWorkbookDataModel",{"[CLIENTES].[REFERIDO].&[Leticia Sanchez]","[PAGOS].[#MOV].&[1619]","[PAGOS].[FECHA].&[2014-09-01T00:00:00]",

=CUBEVALUE("ThisWorkbookDataModel",$G143,H$4)


Those are my formulas, those are created by excel when i convert my pivot to formula using OLAP.

These are the values I get from those formulas: Leticia Sanchez 1619 1-Sep-14 R 0.1 0.5 $3,489.66


So when I create a new record on the table that is source to this converted pivot table, let say record 1620, my converted pivot won't show the new record, although the not converted does....

 

[evelez]

nobody?