locked
add column from list to excel sheet RRS feed

  • Question

  • i have sharepoint 2007 enterprise

    and i have one custom list,this list i export it to spread sheet to use it as report and now i add new column to this list how can i add this coulmn to existing excel sheet.

    thanks for help


    Thanks for any help :) my blog is: http://www.waelk.com

    Wednesday, November 21, 2012 11:50 AM

All replies

  • thanks for your reply but it is not reall helping me.

    1- if i copy and past the data it will not work becouse everytime i open the excel it is refresh the data frm some connection between excel and sharepoint list and get the updates.

    2- if we try to analysis the thing her we have excel file with link or connection to sharepoint list so im sure the is place to change somthing in this connection my question is how to modifay it.


    Thanks for any help :) my blog is: http://www.waelk.com

    Wednesday, November 21, 2012 12:46 PM
  • Hi,

    Since now you have mentioned that you are 'refreshing' the data in Excel so my previous post is not valuable here. The excel file that you exported is connected to a view, not to the list. Therefore, you need to add the new column to this view apart from adding it to the list. Afterward, refresh your excel data.

    See this similar thread:

    http://superuser.com/questions/230904/how-do-i-get-a-new-column-from-a-sharepoint-list-into-excel

    Let us know your result


    Hemendra: "Yesterday is just a memory,Tomorrow we may never see"

    Whenever you see a reply and if you think is helpful, click "Alternate TextVote As Helpful"! And whenever you see a reply being an answer to the question of the thread, click "Alternate TextMark As Answer

    Wednesday, November 21, 2012 1:06 PM
    Moderator
  • Hi,

    Have you resolved you problem? If yes then could you please provide your solution so other can take benefit of that or if above post help you to resolve your problem then mark it as answer.

    Hemendra: "Yesterday is just a memory,Tomorrow we may never see"

    Whenever you see a reply and if you think is helpful, click "Alternate TextVote As Helpful"! And whenever you see a reply being an answer to the question of the thread, click "Alternate TextMark As Answer

    Friday, December 21, 2012 9:36 AM
    Moderator
  • Not solved

    Thanks for any help :) my blog is: http://www.waelk.com

    Saturday, December 22, 2012 8:08 AM
  • Hi,

    Can you please let us know about your problem? as per you requirement, my previous link should work in your case. Please also provide some snap if any error or issue occurred.


    Hemendra: "Yesterday is just a memory,Tomorrow we may never see"

    Whenever you see a reply and if you think is helpful, click "Alternate TextVote As Helpful"! And whenever you see a reply being an answer to the question of the thread, click "Alternate TextMark As Answer

    Monday, December 24, 2012 6:32 AM
    Moderator