Saving templates with links and formulas
 

I have created 5 excel workbook templates with formulas and links
intermingled between the five. I am trying to keep the templates intact and
create working workbooks for current use. How do I do this without losing the
links to the workbooks and screwing up the formulas.

What's the possibility of combining the WBs into one single file?

--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Barb1" wrote in message
...
I have created 5 excel workbook templates with formulas and links
intermingled between the five. I am trying to keep the templates intact and
create working workbooks for current use. How do I do this without losing
the
links to the workbooks and screwing up the formulas.

Not good. What I have is a revenue workbook and an expense workbook, a
profit and loss workbook, and a budget workbook. The budget and P&L workbook
has links to cells in the rev and exp workbooks to gather the information. I
don't want people to input into the templates but to copy them from year to
year to put in their figures, but I can't save a copy without losing the
links. I can't depend on anyone here to recreate the formulas and links
after I'm gone.
"Barb1" wrote:

I have created 5 excel workbook templates with formulas and links
intermingled between the five. I am trying to keep the templates intact and
create working workbooks for current use. How do I do this without losing the
links to the workbooks and screwing up the formulas.