Link External Data stops on row 57
Linked external data exhibits two problems:
1. Linked data is not imported beyond line 57 on a sheet I have. I deleted the external data to re-build the link, but the same problem appeared. When the imported html table is viewed directly, all data is published to the web, but not imported into the zoho sheet.
2. I discovered that any relative formulas on a page with linked data could be corrupted, so I built a reference sheet. But, as linked data was updated automatically with additional records as rows, the relative links on the reference sheet were corrupted--as if the reference sheet had rows inserted at the point where previous linked data ended. As new data accumulates on the linked data sheet, the sheet that refers to it should remain unaffected, as if rows were copied into the external link page, not inserted.
If anyone has a workaround, please advise.