Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Merged cell in Excel 2007 Excel Export — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Merged cell in Excel 2007 Excel Export

41
Views
2
Comments
edited Sep 22, 2016 12:31PM in General Transactional Reporting (OTBI) 2 comments

Summary

Can you remove the merged cell in a 2007 Excel OBI export?

Content

Hello,

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!