Data Missing when using CacheTables

I have a large spreadsheet that summarizes employee benefits by pay control for a given date range. It uses 31 NL sum functions for the benefits, and one NL rows function to populate employees (plus a few minor nl functions for demographic data). When we were running Nav 5 and Jet 9, the report ran in about 5 minutes. Now that we upgraded to Nav 2013R2 and Jet 2015U1, it takes 6 hours.

Upon our conversion testing, we found that many of our spreadsheets would take hours to run instead of minutes, and the solution given to me back then was to add CacheTables to the A1 cell. This has worked for many spreadsheets, and they run fine.

This particular spreadsheet, which went from 5 minutes to about 6 hours or so is not behaving the same way. Adding the CacheTables function worked to speed it up, as it now takes about 3 minutes, but unfortunately, the report is missing most of the data. A few of the early columns populate, but the majority of them do not, and are either completely empty or mostly empty, actually they are not empty, but show as 0. Interesting enough, when I drill down, the drill down window does show the correct entries and has amounts in them.

I refreshed and re-ran, but the same thing. I made the columns absolute reference instead of dynamic. I tried everything I could, but nothing helped. With the CacheTables, the report is missing most of the data. Without the CacheTables, it runs with the correct values, but takes forever.

How do I get this sheet to run properly within a normal time frame?

Thank you,

Lewis