locked
excel file format changes after refresh data from sharepoint RRS feed

  • Question

  • i have sharepoint 2007 and excel 2007

    i do export one list to excel and format my excel file to print in A4 and change some coulms size after i finished and save the file and try to open it again and refresh data to get latest the format change like coulm width.

    how can i keep it even if i refresh the data.


    Thanks for any help :) my blog is: http://www.waelk.com
    Wednesday, October 19, 2011 7:24 AM

Answers

  • Hi wael_e,

    Excel set “Adjust column width” about Data formatting and layout by default, this will make our settings about the format disappearing after refreshing data.

    Please go to Data->Properties, in the External Data Properties dialog, uncheck the “Adjust column width”, and make sure that “Preserve column sort/filter/layout” and “Preserve cell formatting” are checked.

    Thanks,
    Qiao


    Friday, October 21, 2011 8:29 AM
    Moderator