Hi,

I recently created a calculator, which generates quotes based on the calculations from the original excel calculator.

You enter in the specific fields in the excel file, click the hyperlink at the bottom. This opens up the pre-existing (formatted) word document, with the figures feeding from the excel file. I used the 'paste special - unformatted text' method in order to do this.

The excel file is read only, and there is only one master copy of this which everybody uses. When you generate the word document, you would then 'save as'. When you initially generate the word document, there is the pop-up which asks if you are ok to allow the information from excel to be fed into the word document, to which you would select 'yes'.

My problem is, that ever time anyone tries to re-open the newly saved word document, this pop-up comes up. Clicking 'No' keeps the information from when you originally generated the word document, which is what we want it to do. Alternatively, clicking 'Yes' by mistake, opens up a blank document as its obviously trying to feed back to the master excel file.

Is there anyway that once the information feeds through, then this is the information showing and its not then having to try and get updates from the original excel file. Once the information is fed across, I'm hoping there is a way to stop the 'feed' pop-up from coming up again. We are hoping to start sending the quotes out to clients, using this method, and I can see problems occurring if we leave as is.

Any assistance would be greatly appreciated.

Kind regards,