Forum Discussion
Jason Wakefield
Dec 28, 2017Copper Contributor
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_LewinSilver Contributor
Jason,
the compatibility report says it all.
Update your version of Excel.