I understand that exporting a share point List view with calculated column will pull the source columns for that calculated column to excel even if they are not in the view. my issue is there is no data under the source Columns while others can open the excel and they saw the source columns fields have data in them. can someone explain this behavior?
is there a setting in excel makes source columns of a calculated column to have data in them even if they are not in the view? or is the query?