SOLVED

name manager

Copper Contributor

Is there a way to save all created name manager so that it is available for ALL spreadsheets opened?

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@CarriNoE 

I'm afraid not. Defined names are stored in the workbook.

You can refer to defined names in another workbook, for example

 

='OtherWorkbook.xlsx'!SomeName

Ok thanks!
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@CarriNoE 

I'm afraid not. Defined names are stored in the workbook.

You can refer to defined names in another workbook, for example

 

='OtherWorkbook.xlsx'!SomeName

View solution in original post