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.
