I’ve imported data from a 123 spreadsheet many times before. This time I needed to split a 33,000+ row wksheet into 5 smaller wksheets, consisting of 7,999 rows each. My column titles in the 1st row are the same as the fieldnames in the form that I’m using to create documents. There are no hidden or protected cells in the wksheet. I used a range name in order to only import what I need. I converted the original Excel spreadsheet to a 123 file (*.wk4).
After importing, the data does not show in the view. Looking at the document properties, I see the values as fields. My document is basically blank when opened to view. The fieldnames that were in the 1st row have blank values in the document properties.
Anyone have any ideas on what is wrong?