I have had questions about the Domestic Excel file being corrupted. It is not. All versions of Excel can open and read the file; problems occur when trying to sort or manipulate the data.
We are bumping our head on the upper limit of what Excel can handle in the old 97 Excel format, .xls.
We are providing the Domestic TPN Map in the old 97-Excel format as a common denominator, so that older versions of Excel will work. Folks have complaints about functionality when using the free Excel Reader.
Our current TPN Map now runs just under 9,000 records. In the old 97 Excel format, it is about 2.3 MB. In the newer .xlsx format, the same data requires about 900 KB.
There are two options available:
- For Excel 2010 users: just save the .xls file as a .xlsx file. Close Excel, then open the .xlsx version. This newer, smaller version will run fine.
- For Excel 97 users: delete the pages or tabs in the Excel that are not of immediate use - i.e. cut down the file size. Save the remaining data as an .xls. Close Excel then open the stripped-down .xls.