change a function in a workbook without changing every cell
 

I am linking several workbooks to one workbook. The workbooks name change
every month. How can I create a formula that I can change without having to
change every cell in the new workbook?

You can use the 'indirect' function to make a text reference into a life
link. Look at XL help for more

"sir lancelot" wrote:

I am linking several workbooks to one workbook. The workbooks name change
every month. How can I create a formula that I can change without having to
change every cell in the new workbook?

Hi

Indirect is not working with closed workbooks
You can do a EditReplace or if your Excel version have this use
EditLinks

Or if there are not so many cells you must link to use a macro
http://www.rondebruin.nl/summary2.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Naomi" wrote in message ...
You can use the 'indirect' function to make a text reference into a life
link. Look at XL help for more

"sir lancelot" wrote:

I am linking several workbooks to one workbook. The workbooks name change
every month. How can I create a formula that I can change without having to
change every cell in the new workbook?

This appears to work. Thanks for the help.

"Ron de Bruin" wrote:

Hi

Indirect is not working with closed workbooks
You can do a EditReplace or if your Excel version have this use
EditLinks

Or if there are not so many cells you must link to use a macro
http://www.rondebruin.nl/summary2.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Naomi" wrote in message ...
You can use the 'indirect' function to make a text reference into a life
link. Look at XL help for more

"sir lancelot" wrote:

I am linking several workbooks to one workbook. The workbooks name change
every month. How can I create a formula that I can change without having to
change every cell in the new workbook?