Home/ Questions/Q 13262
Next
Answered
computing
  • 6
Asked: 2021-12-12T03:18:59+00:00 In:

Excel 97–2003 & Excel 2013 Compatibility Issues In Win 10

  • 6

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

Share

    1 Answer

    1. Best Answer
      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

      • 0