Is it possible to copy a workbook with several worksheets & formulas to
another workbook without re-entering each formula to reflect a new year? I
created a budget workbook thats linked to another workbook that needs to be
updated every year. I'm able to copy the workbook but I have to put the new
year in each field manually. Are there any shortcuts or commands I can use
to make it less time comsuming? I can post an example of the formulas I use.
Any comments or suggestions will be greatly appreciated. thanks

Hi Nadji,

you have answer in other posts (new users),

Assuming that you have a link to another workbook called budget_2006.xls,
and now you need to change it to budget_2007.xls.

and one of your formulas looks like =[budget_2006.xls]revenue!d4

click on Edit menu and link or bond, (I'm not sure the exact name in
English) and change the source.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Nadji" escreveu:

Is it possible to copy a workbook with several worksheets & formulas to
another workbook without re-entering each formula to reflect a new year? I
created a budget workbook thats linked to another workbook that needs to be
updated every year. I'm able to copy the workbook but I have to put the new
year in each field manually. Are there any shortcuts or commands I can use
to make it less time comsuming? I can post an example of the formulas I use.
Any comments or suggestions will be greatly appreciated. thanks

Thanks this worked you have saved me a weeks worth of work!!!!!!!!!!!!!!!!!!!

"Marcelo" wrote:

Hi Nadji,

you have answer in other posts (new users),

Assuming that you have a link to another workbook called budget_2006.xls,
and now you need to change it to budget_2007.xls.

and one of your formulas looks like =[budget_2006.xls]revenue!d4

click on Edit menu and link or bond, (I'm not sure the exact name in
English) and change the source.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Nadji" escreveu:

Is it possible to copy a workbook with several worksheets & formulas to
another workbook without re-entering each formula to reflect a new year? I
created a budget workbook thats linked to another workbook that needs to be
updated every year. I'm able to copy the workbook but I have to put the new
year in each field manually. Are there any shortcuts or commands I can use
to make it less time comsuming? I can post an example of the formulas I use.
Any comments or suggestions will be greatly appreciated. thanks

you are welcome,


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Nadji" escreveu:

Thanks this worked you have saved me a weeks worth of work!!!!!!!!!!!!!!!!!!!

"Marcelo" wrote:

Hi Nadji,

you have answer in other posts (new users),

Assuming that you have a link to another workbook called budget_2006.xls,
and now you need to change it to budget_2007.xls.

and one of your formulas looks like =[budget_2006.xls]revenue!d4

click on Edit menu and link or bond, (I'm not sure the exact name in
English) and change the source.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Nadji" escreveu:

Is it possible to copy a workbook with several worksheets & formulas to
another workbook without re-entering each formula to reflect a new year? I
created a budget workbook thats linked to another workbook that needs to be
updated every year. I'm able to copy the workbook but I have to put the new
year in each field manually. Are there any shortcuts or commands I can use
to make it less time comsuming? I can post an example of the formulas I use.
Any comments or suggestions will be greatly appreciated. thanks