It does sound as if you have created a MONSTER. Excel does NOT like large
external data bases. It sounds like you need professional help to re-design
your project. I'm pretty sure it could be greatly simplified.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"baldmosher" wrote in message
...
I appreciate that Don, but as I am certain the code itself is not to blame,
I
don't see the sense in posting 9 modules and a few thousand lines!

I do suspect that setting WB = "REPORT.xls" at the start and adding sheets
to this WB as I go along could be the root of my problem, but I am new to
coding so I don't know if I'mbarking up the wrong tree.

The entire report size is approx 3.5MB and the source "report.xls" is
approx
80MB using external data sources. I've created a monster.

Regards
Tom


"Don Guillett" wrote:

Always post your code for comments and suggestions.