You don't need the # to post a sample, just square brackets and CODE as per my signature. Or email me.
Sounds like you might have some templates mixed up, or have accidentally hidden some fields.
Let's start with the basics - are you working with a report as your input data or are you working with a database? Are you exporting to Excel from the Table window or from the Summary?
Edit - issue fixed by converting Append templates to Footers.