Merged cell in Excel 2007 Excel Export
SummaryCan you remove the merged cell in a 2007 Excel OBI export?
When you export a large document from OBI to 2007 Excel, there is a merged cell that is present after the last row of data in the file. This makes sorting and filtering impossible. I know that I can delete the cell, or even export in 2003 Excel to avoid it altogether, but 2007 is the preferred format that we use for most of our scheduled agents, and the merged cell is giving our users some issues.
Does anyone know of a way to remove the merged cell PRIOR to export so that our users won't have to deal with it?