functions between workbooks.
 

Howdie all.
I'm not sure if this is the preferred location to post this, but I need to
start here.
I have a template workbook that I've placed numerous worksheet functions in.
I then have a macro that calls to this template workbook any time that I
need to add a worksheet. This allows me to have easy access to a
preconfigured worksheet.

The problem that I'm facing here is that each time I go perform my standard
work on my new page, I find that my worksheet functions are directly tied
back to my template file.

I.e., =subtotal(103,a1:a24) becomes
=subtotal(103,'C:\Docs & Settings\MyName\Appl.Data\MS\TEmplates'! ShtNmA1:a24)

Yes, I abbreviated all the folders for ease of typing.

My question:

Is there some way that I can prevent this from occurring in the future?


The formulas are already on my worksheet because I set it up that way so I'd
have a commonly configured sheet throughout all my work.

Thank you.
Best,
SteveB.

functions between workbooks.
 

Hi,

Well I have one fix for you, choose Edit, Links, select the source you to
your template and click Change source. Navigate to where the file you are
currently in is located and select it. This will change all references to
the active workbook.

--
Thanks,
Shane Devenshire


"SteveDB1" wrote:

Howdie all.
I'm not sure if this is the preferred location to post this, but I need to
start here.
I have a template workbook that I've placed numerous worksheet functions in.
I then have a macro that calls to this template workbook any time that I
need to add a worksheet. This allows me to have easy access to a
preconfigured worksheet.

The problem that I'm facing here is that each time I go perform my standard
work on my new page, I find that my worksheet functions are directly tied
back to my template file.

I.e., =subtotal(103,a1:a24) becomes
=subtotal(103,'C:\Docs & Settings\MyName\Appl.Data\MS\TEmplates'! ShtNmA1:a24)

Yes, I abbreviated all the folders for ease of typing.

My question:

Is there some way that I can prevent this from occurring in the future?


The formulas are already on my worksheet because I set it up that way so I'd
have a commonly configured sheet throughout all my work.

Thank you.
Best,
SteveB.

functions between workbooks.
 

Hi Shane,
Thanks.
It's definitely easier than having to edit multiple functions.
I'd seen that before, and often wondered what that was good for.
Best,
SteveB.


"ShaneDevenshire" wrote:

Hi,

Well I have one fix for you, choose Edit, Links, select the source you to
your template and click Change source. Navigate to where the file you are
currently in is located and select it. This will change all references to
the active workbook.

--
Thanks,
Shane Devenshire


"SteveDB1" wrote:

Howdie all.
I'm not sure if this is the preferred location to post this, but I need to
start here.
I have a template workbook that I've placed numerous worksheet functions in.
I then have a macro that calls to this template workbook any time that I
need to add a worksheet. This allows me to have easy access to a
preconfigured worksheet.

The problem that I'm facing here is that each time I go perform my standard
work on my new page, I find that my worksheet functions are directly tied
back to my template file.

I.e., =subtotal(103,a1:a24) becomes
=subtotal(103,'C:\Docs & Settings\MyName\Appl.Data\MS\TEmplates'! ShtNmA1:a24)

Yes, I abbreviated all the folders for ease of typing.

My question:

Is there some way that I can prevent this from occurring in the future?


The formulas are already on my worksheet because I set it up that way so I'd
have a commonly configured sheet throughout all my work.

Thank you.
Best,
SteveB.