How to create a Global scope name range

[Sean15]

Hi:

How does one create a name range that will be available to any worksheet or workbook or any newly created worksheet? I tried setting named range scope to “worksheet” but the name range is not available to another workbook or newly created worksheet. Could someone help please?


Regards,

Sean

 

[shg]

Create a workbook with the names (and anything else you like -- styles, fonts, custom number formats, ...) and save as Book.xltx in your XLSTART folder. That becomes the default template when you start Excel or do Ctrl+N (new workbook).

If the workbook has more than one sheet, delete all but one and save that as Sheet.xltx in the same folder. That becomes the default template when you add a worksheet.

 

[Sean15]

Hi:

Thanks for your help. I am on a corporate network and I am not allowed anywhere beyond our department’s network drive. Is there another way to do this? I have 75 workbooks I have to update today and I just need to reuse the five named ranges I created in workbook no1. Is it that I have to re-create the named range every time?


Regards

Sean

 

[shg]

If a given workbook has all these names, in what way are you using them?

 

[shg]

I should note that you can write code to add dynamic or static names to any workbook.

 

[Sean15]

Hi

I have a main worksheet with account no, opening and closing balances. I created name range for each heading. I use INDEX and MATCH to get required values. Named ranges were created in workbook A. I just can’t get the name ranges to appear in workbooks B, C...

Regards

Sean

 

[shg]

Record a macro adding the names?