Possible Jet or Excel Limitation?


I'm trying to run a report that spans a lot of records over several months in the Item Ledger Entry table. The report failed with a "PivotTable2 invalid reference". When I clear that error, there #VALUE cell also clears, so there's nothing to debug.

I tried refreshing the report a few days at a time until I found the date that was causing trouble. Then, I refreshed the report using that date and the day immediately following, and it refreshed with no issue.

I'm worried that I've hit a limit with either Jet or Excel. Any thoughts on where or what to check?


Please sign in to leave a comment.