WARNING: An open report contains CalcFields or CalcFilters


I have a file with a warning when I open it:

An open report contains CalcFields or CalcFilters, and Excel cannot execute Jet functions on multiple threads.  As a result, your reports may run slower until you restart Excel.

This is not an error just a warning.  The report works well if I execute with Excel opened, it takes about 45min.  However when I schedule the report it doesn't work well, it creates a pdf with only 1 page in a minute without any calculation on it (it is supposed to have more than 200 pages).

Why does this happen?

Thank you!!


Please sign in to leave a comment.