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 Edit>Replace or if your Excel version have this use
Edit>Links

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" <[email protected]> wrote in message news:[email protected]...
> 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 Edit>Replace or if your Excel version have this use
> Edit>Links
>
> 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" <[email protected]> wrote in message news:[email protected]...
> > 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?
>
>
>