Excel 97–2003 & Excel 2013 Compatibility issues in Win 10

September 9, 2015 at 07:17:08
Specs: Windows 7
Hi Guys
Have a few problems with Excel Workbook that I have memory sticked from my old laptop to new computer. Old laptop is Excel 97 - 2003 and new computer is excel 2013

Once I loaded the worksheet from the memory stick, I have opened the workbook and it is not working as it has been. I have noticed that some of the Form Control Buttons are missing as well

I have run a Compatibility Check and it has thrown up a number of issues

Compatibility Report for SAS2.xlsm
Run on 09/09/2015 14:46

The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when opening this workbook in an earlier version of Excel or if you save this workbook in an earlier file format.

Significant loss of functionality # of occurrences Version

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. 19749
DASHBOARD'!H6:H29 Excel 97-2003
DASHBOARD'!M6:M29
Excel 97-2003
Excel 97-2003

Could someone elaborate on the above, as I am not sure what it is telling me
Look forward to a response

Tony


See More: Excel 97–2003 & Excel 2013 Compatibility issues in Win 10

Report •


#1
September 9, 2015 at 07:33:32
It pretty much means you won't be able to open that file in Excel versions 97 - 2003.

Report •

#2
September 9, 2015 at 07:50:29
Just to be clear, what your saying is that the Excel Workbook 97 - 2003 will NOT know work in excel 2013

Report •

#3
September 9, 2015 at 07:55:05
I've have had similar warnings, essentially, it mean you can NOT save the workbook in a Excel 97 - 2003 format of XLS.
If you try, then you will loose all the functionality listed in the warning message.

You have to save the file in the new file formats to retain the functionality.

Are the Form Control button linked to a Macro?

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

Related Solutions

#4
September 9, 2015 at 08:25:42
Thanks for the replies guys, but will have to come back to this later. Off on my hols as of now

Report •

#5
September 9, 2015 at 11:39:13
re: "I've have had similar warnings, essentially, it mean you can NOT save the workbook in a Excel 97 - 2003 format of XLS.
If you try, then you will loose all the functionality listed in the warning message.
"

Mike,

I'm a little confused by your wording. Are you saying that you will lose the listed functionality if you even try to save the file as a .xls file and that you will not even be able to save it or are you saying that if you actually save it as a .xls you will lose the functionality?

Those are 2 very different scenarios.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#6
September 9, 2015 at 12:11:19
DerbyDad03:

If you actually save it as a .xls you will lose the functionality.

Part of the warning states:

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.

As you know in 2007 onward the worksheet size is 16,384 columns by 1,048,576 rows, while the worksheet size of Excel 97 through Excel 2004 is limited to 256 columns by 65,536 rows.
So the warning is telling you that data in cells outside of this column and row limit will be lost if you save it in Excel 97 format.

MIKE

http://www.skeptic.com/


Report •

#7
September 9, 2015 at 14:18:26
Right...that was my understanding.

It's not the trying that eliminates the functionality, it's the actual saving.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question