Output to Excel brings in Extra Columns...
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
June 5th, 2012 1:01pm

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/
Free Windows Admin Tool Kit Click here and download it now
June 5th, 2012 4:55pm

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.
June 6th, 2012 11:55am

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
Free Windows Admin Tool Kit Click here and download it now
June 6th, 2012 11:59am

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.
June 6th, 2012 12:05pm

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.
Free Windows Admin Tool Kit Click here and download it now
June 6th, 2012 12:08pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics