compatibility error message

[Anas_Raza]

i have a sheet which is saved in excel 2003 and gives following error

Compatibility Report for Stock Register Store.xls
Run on 02-03-2015 22:54

The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when you save this workbook in an earlier file format.
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.


how i can over come thins error message?

 

[Jonmo1]

how i can over come thins error message?

Only 2 ways I can think of..

1) Don't save the file in Excel 97-2003 format, use Excel Workbook(*.xlsx or *.xlsm) instead

2) Don't use more than 256 columns (IV) and/or 65,536 rows in a sheet or formula reference.