We have set the distribution to convert to values when publishing the report.  All the tabs do this except one.  The enable edit option comes up in excel when the user who received the report opens in excel and if they click the button then cell populates with the function and returns #NAME?   All the other tabs in the report return static values.  

Any ideas why this would happen on one worksheet in the report set.

Thanks.