Forum Discussion
Excel not recognising header row
Hi, I'm using Office 365, and have a fairly old spreadsheet originally compiled in an older version. I'm trying to sort the data; I tick the box that says my data has header rows, and this is ign...
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
Thanks for your speedy reply.
As a workaround, I pasted the header row into another sheet and deleted it, and sorted the data with no header row. All was well.
Then I inserted a row at the top, and pasted my headers back again.
The spreadsheet is now sorting perfectly. Very strange. Taking the header row out and putting it back seems to have cured it.
KPT
As a workaround, I pasted the header row into another sheet and deleted it, and sorted the data with no header row. All was well.
Then I inserted a row at the top, and pasted my headers back again.
The spreadsheet is now sorting perfectly. Very strange. Taking the header row out and putting it back seems to have cured it.
KPT
Glad you found a workaround/solution.