Forum Discussion

Jason Wakefield's avatar
Jason Wakefield
Copper Contributor
Dec 28, 2017

excel compatibility issue.

Im try to open a worksheet and only partial data opens.  I'm thinking a compatibility issue not sure what work around I can use

 

Thanks

 

 

 

Compatibility Report for Scorecard Reports PER 12 2017 CUR AND YTD.xlsx        
Run on 12/28/2017 8:27        
         
If the workbook is saved in an earlier file format or opened in an earlier version of Microsoft Excel, the listed features will not be available.        
         
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.     1  
        Excel 97-2003
         
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.     1
Defined Names
Excel 97-2003
         
One or more functions in this workbook are not available in versions prior to Excel 2007. When recalculated in earlier versions, these functions will return a #NAME? error instead of their current results.     1580  
      CL Scorecard PTD'!C15:R15 Excel 97-2003
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
      CL Scorecard YTD'!C15:T15 Excel 97-2003
      CEM Scorecard PTD'!C15:J15 Excel 97-2003
      CEM Scorecard YTD'!C15:J15 Excel 97-2003
      BEC Scorecard PTD'!C15:R15 Excel 97-2003
      BEC Scorecard YTD'!C15:R15 Excel 97-2003
      TRP Scorecard PTD'!C15:S15 Excel 97-2003
      TRP Scorecard YTD'!C15:S15 Excel 97-2003
      ELB Scorecard PTD'!C15:E15 Excel 97-2003
      ELB Scorecard YTD'!C15:E15 Excel 97-2003
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Jason,

     

    the compatibility report says it all.

     

    Update your version of Excel.

     

Resources