Headers

Options
Hello everyone!

I set up an Export awhile ago, and renamed the headers so I wouldn't have to do it everytime in Excel. Now that we are in a new Fisical year, I need to change one of the headers in the Export to reflect that, but it WILL NOT let me. I even tried recreating the export from scratch, and it won't let me do it there either! I am wondering if anyone else has run into this?

Comments

  • Marie Stark
    Marie Stark ✭✭✭✭✭
    Ancient Membership Facilitator 3 Name Dropper Photogenic
    Is it possible that the export format was changed to something other than Excel?

     
  • Hi Tammie-


    In the event you are building a Conditional Word merge, in my experience, the header in the first letter is used in every subsequent letter, but you mentioned Excel so this is probably not the issue you're experiencing. Just thought I'd put that out there in case the two issues are related.
  • Have you tried right clicking the data item in the Export Output tab? Column Heading should be an option and you can change it. The same option shows for me in a query.

    9c8d89a0c2996fe24d2305c450d52e2b-huge-ex
    4a3bcbfe5676fefe21ba38990652d3c1-huge-qu

     
  • Oh, she means a column header! That makes more sense. I'll add another useless comment that if you created a new Export and accidentally chose Word instead of Excel, you can't rename Column Headings in a Word Export. Maybe that's what you are experiencing?

    ad76051bebc2adbf642fdd7d81e86222-huge-ex

     
  • Sorry! Yes I meant column header. I actually have it Exporting into Access because I need to link to data from another database. When I changed it from Access to Excel, it let me change the Column Header.  

    Frustrating.




    Aaron Rothberg
    :

    Oh, she means a column header! That makes more sense. I'll add another useless comment that if you created a new Export and accidentally chose Word instead of Excel, you can't rename Column Headings in a Word Export. Maybe that's what you are experiencing?

    ad76051bebc2adbf642fdd7d81e86222-huge-ex

     

     

  • Glad you figured it out and yes, if you choose to Export to dBase, Access, WordPerfect, Lotus, basically any output type other than XLS or CSV, you can't change the Column Heading.

Categories