Excel 2007 : How many pivot tables can Excel 2007 handle?

Hi, I have a large Excel 2007 document that is up to 57 pivot tables and will have another 22 before I'm done with it. There are 5 master pivot tables and those 5 pivot tables filter out to the 74 sub-pivot tables. Here is my problem, as I was creating the sub-pivot tables, the configuration settings for the pivot tables stopped working. All of the pivot tables use the exact same configuration settings, but after around 35 pivot tables, the new pivot tables stopped following the configuration settings. Am I exceeding the abilities of Excel 2007, so it is not working as it should, or is there something else causing the issue?

This is the issue I am having. I have the pivot table configured to "Show Items With No Data", but after the 35th pivot table, the setting stopped working. The only way for this spreadsheet to work for me is if I can get to the full 79 pivot tables, so I need to know if I am asking too much of Excel.

Thanks in advance for your assistance.

Duncan