0
I have created a template in MS Excel 2003. In MS Excel 2007, when I save it in MS Excel 1997 - 2003 format, it gives a compatibility warning;
Significant loss of functionality
This workbook contains data in cells outside of the row and column limit of the selected file format. Data beyond 256 (IV) columns by 65,536 rows will not be saved. Formula references to data in this region will return a #REF! error.
I can't figure out why Excel 2007 is showing this error while I have not used more than 50 rows and 14 (N) columns. I have googled it and found many solutions (actually suggestions) but no solution helped me solve this. Anybody here, who knows the solution or at least lead me in the right direction.
Mudassir
Posted 2013-03-25T08:33:56.070
Reputation: 101
Are you sure there's no data outside the limits? Have you tried copying only the data from your 50*14 section, pasting into a new document and then saving that? – Karan – 2013-03-25T09:33:40.510
1what cell do you get taken to when you hit Ctrl-End? – mcalex – 2013-03-25T09:58:38.080
@Karan: I am sure that there is no data outside those 50 rows and 14 columns. Let me try pasting the contents to a new sheet. – Mudassir – 2013-03-25T10:08:19.427
@mcalex: In Excel 2003, I am seeing the 65536 as the last row. – Mudassir – 2013-03-25T10:08:59.100
@Karan: I tried your suggestion but the problem still persists. – Mudassir – 2013-03-25T12:41:44.290
If Ctrl-End takes you to row 65536, that's how big Excel thinks your sheet is. Copy just the data (not entire rows or columns) to a sheet in a new workbook, save it and then see where Ctrl-End takes you. – mcalex – 2013-03-25T18:19:55.087
1Thank you guys for your time. I solved it, please see the answer below. @mcalex: I pressed 'Ctrl + Down Arrow', (instead of 'Ctrl + End', as suggested by you) that is why it is taking me to the last (65536th) row. My sheet actually has only 50 rows. – Mudassir – 2013-03-26T08:51:53.430