I bump into a problem this week with a multi workbook setup 14 workbooks, three tiers with parent, child and grandchild, 168mb in total.
During one of the worst attempt to export a custom historical income statement module took 6 hours, or hour and half for duplicate.
IT had a diagnostics, quoting high memory utilization and ordered a 16GB ram and installed it.
So now have got exorbitant 32GB RAM. But when try with export module again there seems to be an invisible cap the memory consumption had never been over 50% or 16GB.
