compatibility error message

Anas_Raza

Board Regular
Joined
Dec 18, 2013
Messages
60
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?
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,007
Messages
5,465,976
Members
406,458
Latest member
Barboza Babcock

This Week's Hot Topics

Top