MPCPushData formula

You can specify an Excel formula, such as =A1+B1, over an MPCPushData formula. In this case, you are prompted with a message asking if you would like the result of the new formula to be written to the same cell in the dataset. Select Yes to replace the old value formula in the MPCPushData formula with the new formula you specified. The edited MPCPushData formula will continue to write results to the dataset. Select No to create an Excel Type 1 formula that will not write results to the dataset. You will still be able to lock or constrain the cell, and any values specified over the formula will top down spread to MPCData formulas and Excel value cells.