I am new to this forum and hoping that my fix will be easy and painless. I have a spreadsheet with 16 adjacent columns with numeric and text data. There are headings at the top of each column describing the data in that column. I sort the data in many of the rows in ascending or descending order to facilitate quicker data input. Once the data is input, I then sort numeric data to rank all the data in the rows accross that portion of my spreadsheet. There are formulas and functions in some of the cells referencing other areas of the spreadsheet. I have never had an issue sorting the data.
Just recently, the top 4 rows of my spreadsheet have locked up and won't sort, regardless of which column I attempt. The data in all of the rows below the top 4 rows sorts correctly. Have I inadvertantly protected or frozen these rows thus disabling the sort function? Perhaps somehow my sort function is looking at those 4 rows as if they are headers and thus not included in the sort?
I do updates on two different computers, one which runs excel 2007, and the other runs excel 2010. I am wondering if there is a compatability issue between the versions, or if there is something else. Any assistance would be greatly appreciated.
Bookmarks