Skip to main content
Formatting; copy edit
Source Link
Paul White
  • 90.3k
  • 30
  • 424
  • 663

Here are the possible reasons and solutions iI can think of:

  1. The excelExcel file instance may be getting opened in the protectedprotected mode. Opening,opening saving, and closing them is solving this issue temporarily,but for fixing permanently. To fix it permanently, you need to add the excelExcel file location as a trusted one in the Trust centerCenter.

For doingTo do this, you need to gotogo to excel>>file>>options>>Trust center>>trust center settings>>Trusted locations.excel>>file>>options>>Trust center>>trust center settings>>Trusted locations. and add the location of your excelExcel file there.

  1. Another thing that you can try is changing the file block settings in the same options window for excelExcel 2007, and later file types according to your needs.

  2. The last reason that iI can think offof is excel is unable to identify the type of value being inserted in the columns,thisExcel is unable to identify the type of value being inserted in the columns. This problem is resolved by entering some default sample values in the 1stfirst row for each column,this. This workaround helps excelExcel in deciding what kind of value is getting entered and most of the timestime fixes the format issue.

For example:

column1_has_to_get_integer_valuecolumn1_has_to_get_integer_value then insert any integer value in first row. column2_has_to_get_string_valuecolumn2_has_to_get_string_value then insert any string value in first row.

Hope this helps.

Here are the possible reasons and solutions i can think of:

  1. The excel file instance may be getting opened in the protected mode,opening saving and closing them is solving this issue temporarily,but for fixing permanently it you need to add the excel file location as trusted one in Trust center.

For doing this you need to goto excel>>file>>options>>Trust center>>trust center settings>>Trusted locations. and add the location of your excel file there.

  1. Another thing that you can try is changing the file block settings in same options window for excel 2007 and later file types according to your needs.

  2. The last reason that i can think off is excel is unable to identify the type of value being inserted in the columns,this problem is resolved by entering some default sample values in the 1st row for each column,this workaround helps excel in deciding what kind of value is getting entered and most of the times fixes the format issue.

For example:

column1_has_to_get_integer_value then insert any integer value in first row. column2_has_to_get_string_value then insert any string value in first row.

Hope this helps.

Here are the possible reasons and solutions I can think of:

  1. The Excel file instance may be getting opened in protected mode. Opening, saving, and closing them is solving this issue temporarily. To fix it permanently, you need to add the Excel file location as a trusted one in the Trust Center.

To do this, you need to go to excel>>file>>options>>Trust center>>trust center settings>>Trusted locations. and add the location of your Excel file there.

  1. Another thing that you can try is changing the file block settings in the same options window for Excel 2007, and later file types according to your needs.

  2. The last reason that I can think of is Excel is unable to identify the type of value being inserted in the columns. This problem is resolved by entering some default sample values in the first row for each column. This workaround helps Excel in deciding what kind of value is getting entered and most of the time fixes the format issue.

For example:

column1_has_to_get_integer_value then insert any integer value in first row. column2_has_to_get_string_value then insert any string value in first row.

Source Link
Shivam Kumar
  • 354
  • 1
  • 2
  • 8

Here are the possible reasons and solutions i can think of:

  1. The excel file instance may be getting opened in the protected mode,opening saving and closing them is solving this issue temporarily,but for fixing permanently it you need to add the excel file location as trusted one in Trust center.

For doing this you need to goto excel>>file>>options>>Trust center>>trust center settings>>Trusted locations. and add the location of your excel file there.

  1. Another thing that you can try is changing the file block settings in same options window for excel 2007 and later file types according to your needs.

  2. The last reason that i can think off is excel is unable to identify the type of value being inserted in the columns,this problem is resolved by entering some default sample values in the 1st row for each column,this workaround helps excel in deciding what kind of value is getting entered and most of the times fixes the format issue.

For example:

column1_has_to_get_integer_value then insert any integer value in first row. column2_has_to_get_string_value then insert any string value in first row.

Hope this helps.