i am working with a multisheet excel document that was forwarded to me with all kinds of formatting and titles that inhibti my ability to split the windows and to effectively copy and paste the data as the large raw file of 44,000 records it is.

so i thought i would save as .csv hoping to loose all that formating but excel will not allow me to because it is a multi-sheet document. so why can't i just tell it to save the sheet i'm working on as a .csv. somehow this file has been sorted or played with so some of the row numbers are missing and i can't even just select and past all the data into a new single sheet excel document so i can then save it as a csv. hopefully and loose these odditys. i don't even know how you get row numbers to disappear or why that would be desirable, but probalby just haven't thought of every conceivable circumstance.

any help or suggestions appreciated.