Vlookup glitchy

[sodaspop]

Been using XLS files for years with MS Excel under Windows 98 and Windows 7. One file, "ledger," has several worksheets and Vlookup tables used by another file, "invoice." "Invoice" was usually opened and was able to access the tables OK without "Ledger" being opened (The link message to Ledger properly comes up when Invoice is opened).
New computer, Windows 10, Planmaker 2018: when "Invoice" is opened and accesses "Ledger," not opened, the Vlookup works fine as it had but only finds data in the first half of the Vlookup (row) range. The table in "Ledger" goes from A2:C400. The Vlookup works fine up to row 201, then any lookup in the table past that row returns zeroes. The workaround is to have "Ledger" opened in the background before "Invoice" is opened, and then "Invoice" successfully fetches data in rows past 201. Why would Vlookup bail after half of the table is accessed when the file with the tables is closed and work OK only after the file with the tables is opened first.
Lookup column is properly numbered in sequence, nothing unusual

[SuperTech]

Thanks for reporting this problem. Please share the associated file of PlanMaker in which you are getting this problem so that we can do further investigation for resolution.

If you want to send it to us privately, please e-mail us at the forum[at]softmaker.de

Please also include the forum URL of this topic so that we can trace your e-mail.
viewtopic.php?f=300&t=20782&p=68770#p68770

[SuperTech]

Thanks for sharing the files. I was able to reproduce the problem and forwarded the details to our development team for further investigation.