When I use the keyboard Shortcut Ctrl + Down to go to the last used row of my spreadsheet I land on the empty row below my OBIEE data export. I have found that sometimes when importing data into Access this extra row gets picked up, so I have been having to manually remove it in a number of reports. Is there a setting that will allow me to eliminate this extra "blank" row? While I can delete the row it would be nice if I can create an export that doesn't have this extra "blank" row embedded in my data. It is always one below the last row that contains data. Anyone have any ideas? Is this some kid of carriage return or something that's being picked up that I can't see?
I'm not referring to the merged row that says "Rows 1-XXX".