Hi, I hope someone can help

I have created a very complex spreadsheet for designing some equipment and there are numerous outputs. I have then basically embedded a word document into the spreadsheet which is in effect a quote for the equipment that has been designed using the spreadsheet. I have then "linked" data from the spreadsheet into the embedded Word Document. As the spreadsheet design changes, so then does the quote. This seems to work quite well, however, there are possibly 150+ links into the word document, and having now completed half the links, I am getting insufficient memory errors and I suspect my "approach" is not the best way. Guidance on a more efficient approach would be most welcome.

My goal is to only have one document if I can help it, as I remain concerned that a seperate word and excel file, may lead to one getting lost [or the links broken]. The intention is that this excel file would be sent to thrid parties to design our equipment, and the idea was that they would never see the word file, but just have the option of "printing a quote" using a simple macro in Excel.

Many thanks in advance

Pete