Hi 

I have created a travel package calculation spreadsheet. I have saved it as a template, and my plan is that for each travel package we have, we shall create a new document.

In in the original document/template – i have a seperate tab called Data! where i have exchange rates, different mark-up levels depending on what kind of product it is, and admin and visa fees. 

My thought is that when creating a new package, i use the template and save a copy for each travel package. But i want the new files to be linked to the oringal templates, so that when i change the exchange rates this will be reflected in each new file. The update of exchange rates does not have to be automatically, but i would like to go into each file, and push a button

​Hi  I have created a travel package calculation spreadsheet. I have saved it as a template, and my plan is that for each travel package we have, we shall create a new document. In in the original document/template – i have a seperate tab called Data! where i have exchange rates, different mark-up levels depending on what kind of product it is, and admin and visa fees. My thought is that when creating a new package, i use the template and save a copy for each travel package. But i want the new files to be linked to the oringal templates, so that when i change the exchange rates this will be reflected in each new file. The update of exchange rates does not have to be automatically, but i would like to go into each file, and push a button  Read More

​