Reports not listing entries when it should
We manage store fitouts. With every project, the sheets are identical. I have created 16 sheets to manage 16 projects.
I have just recently added few rows, all identical, on all 16 sheets.
When I run reports, it does list certain rows (newly created).
Puzzled, I simplified the report to the bare minimum: I now search rows which "contains" a simple word in the primary column. Couldn't be simpler.
It displays the rows from 8 sheets only, when there should be 16 rows displayed (as there are no difference whatsoever between the 16 sheets).
Note: It only happens with the newly created rows. If I query to display a word from an original row (not a recently added row), it displays all 16 rows.
What could have gone wrong? It is also so random: Why 8 rows, not all 16 rows?
Can someone help?