locked
Output to Excel brings in Extra Columns... RRS feed

  • Question

  • Hello

    So my issue has to do with outputting a custom view to excel.

    For instances, I have 5 columns. ID | Name | Team | Annualized Savings | Savings %|

    ID is obviously automatic, Name is a Single Line Text field, and Team is a choice menu... But

    Annualized savings is a calculated field based off of 12 other currency columns[column 1 + Column 2 + ... Column 12] = Annualized savings. and same with Savings %.

    Even though those 12 columns are not in my custom view they are still in the excel output.. How come.

    Thanks

    Brandon

    Tuesday, June 5, 2012 4:55 PM

Answers

  • Not that I'm aware of Brandon.  The output is very linear, you can only change the order of the columns by changing your view in the SharePoint list prior to exporting if you wanted too.  Data will be exported as seen, remember that each item will always become a spreadsheet row.

    Paul Turner http://redmanta.co.uk/blog Twitter: @RedMantaUK MCTS:WSS,MOSS,2010 MCITP:2010.
    Please remember to click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if it was useful.

    Wednesday, June 6, 2012 4:05 PM

All replies

  • Hello,

    This could be because of the the calculated column is referring to the other column values

    Try steps from :http://sharepoint-administration-eu.blogspot.in/2012/03/unable-to-export-columns-from.html

    The later steps to change the view GUID should help.


    Regards | Rohan Chittyal | Sharepoint Technologies | http://sharepoint-administration-eu.blogspot.com/

    Tuesday, June 5, 2012 8:49 PM
  • This is the expected behaviour Brandon.  The Excel Export will always show the calculated columns.  If it didn't your Annualized Savings column would not function as there would be not formula or figures to generate it.

    Paul Turner http://redmanta.co.uk/blog Twitter: @RedMantaUK MCTS:WSS,MOSS,2010 MCITP:2010.
    Please remember to click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if it was useful.

    Wednesday, June 6, 2012 3:52 PM
  • Hey Paul

    Yes I figured that. I just delete what I do want to see and save it so that it isn't there after I refresh the Excel.

    I have another question regarding the Excel output that maybe you can confirm for me.

    Is there a way to move around headings so that I can format the way the excel output looks like to me. Because I need to have diffrent columns match with specific rows.

    To give you a visual I would like to move the ID Column heading from A1 to say B3 ( I don't know why anyone would want to do this but just an example)

    Thanks

    Brandon

    Wednesday, June 6, 2012 3:56 PM
  • Not that I'm aware of Brandon.  The output is very linear, you can only change the order of the columns by changing your view in the SharePoint list prior to exporting if you wanted too.  Data will be exported as seen, remember that each item will always become a spreadsheet row.

    Paul Turner http://redmanta.co.uk/blog Twitter: @RedMantaUK MCTS:WSS,MOSS,2010 MCITP:2010.
    Please remember to click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if it was useful.

    Wednesday, June 6, 2012 4:05 PM