Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) User added/embedded co...

User added/embedded columns in Dynamic Worksheet gets erased (overwritten)

(1) Share

Report

Posted on by Community Member Microsoft Employee

Hello Community,

My organization just recently updated to CRM 2016, previous in the 2013 version. With CRM 2013, I was able to embed columns between dynamic columns when exporting a Dynamic Worksheet. When I would refresh, the dynamic columns would of course update and my embedded would maintain their positions.

See picture below. The orange is my embedded column that contains a formula.

When playing around, it seems that the new 2016 Dynamic Worksheet does a clean wipe and then re-pastes the original dynamically exported view, even when a column is deleted. In 2013 version, if I deleted a column from the worksheet, this column would not re-appear upon refresh the link. In both version, deleted rows come back.

I even tried to move the added user column to the farthest right column but with no luck upon refresh, see second picture. Formulas still work but heading is gone.