locked
Sharepoint list Export to Excel issue RRS feed

  • Question

  • I have a list with different views. when i exporting the list items to excel it works fine for few views. when i try to export the allitems view it fails. it exporting few items only. then i compared the other views which are working fine, what i got to know is the allitems view contains a field Currency. when exporting to excel it failing when the item contains the Currency(with $ symbol) value.

    The list is customised based on the custom list.

    can some one please suggest how i can achive this?

    thanks in advance..!

    Rajender.



    • Edited by Rajender.G Thursday, January 19, 2012 9:56 AM
    Thursday, January 19, 2012 6:34 AM

All replies

  • How large is the list?  Some column types are known to give problems.  I'd take a template copy of the list, change the currency type into a number and try exporting that.  It should retain your values as a straight numeric.

    If it works, make the change on the live list and see how that works out.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    • Marked as answer by Wayne Fan Friday, January 27, 2012 3:41 AM
    • Unmarked as answer by Mike Walsh FIN Thursday, February 2, 2012 3:48 PM
    Thursday, January 19, 2012 1:56 PM
    Answerer
  • Hi Steven,

    The list has 350 items with 21 columns. I tried to take the list template including content but got failed. Its giving below error.

    "The list is too large to save as a template. The size of a template cannot exceed 50000000 bytes"

    Expecting Currency column is a calculated value. It automatically filled from another list.

    Please suggest on this.

    Thanks


    Rajender.

    • Edited by Rajender.G Thursday, February 2, 2012 10:10 AM
    Thursday, February 2, 2012 9:55 AM