Export to Excel error

Brendan Broughton
Brendan Broughton Active Partner
Third Anniversary 100 Comments 100 Up Votes 25 Likes
in Platform

Anyone in the community had this error pop up before when extracting to Excel?

image

Tagged:

Answers

  • Andrea Masiero
    Andrea Masiero Employee
    Third Anniversary 10 Comments Level 100: Foundations of Building in Board 5 Up Votes

    It's probably because you have a special character in the layout title (which will become the sheet name of your excel) and this can't be exported in excel. 

    This is a first thing i would control...

  • Brendan Broughton
    Brendan Broughton Active Partner
    Third Anniversary 100 Comments 100 Up Votes 25 Likes
    edited March 2020

    Thanks Andrea, but the layout is in the BFC Internal Reporting capsule, and there are no special characters in the title so it must be something else.

    image

  • Leone Scaburri
    Leone Scaburri Employee
    Fourth Anniversary 100 Comments 5 Answers 25 Likes

    Can also be something within entity templates you applied. Try to extract without any template.

  • Unknown
    Unknown Active Partner

    This occurs when there are specific border colours applied - so you need to update the Entity Formatting and remove borders.  (Our company does have tickets raised with Board about this - one suggested workaround is that the data-view should be able to be successfully exported from Web, rather than the Windows client ... although I'm yet to confirm this myself).  Hopefully the fix will not be too far away, as we now have several clients getting frustrated by this issue

Categories