name manager

%3CLINGO-SUB%20id%3D%22lingo-sub-2636563%22%20slang%3D%22en-US%22%3Ename%20manager%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2636563%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20save%20all%20created%20name%20manager%20so%20that%20it%20is%20available%20for%20ALL%20spreadsheets%20opened%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2636563%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2636624%22%20slang%3D%22en-US%22%3ERe%3A%20name%20manager%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2636624%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1126011%22%20target%3D%22_blank%22%3E%40CarriNoE%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'm%20afraid%20not.%20Defined%20names%20are%20stored%20in%20the%20workbook.%3C%2FP%3E%0A%3CP%3EYou%20%3CEM%3Ecan%3C%2FEM%3E%20refer%20to%20defined%20names%20in%20another%20workbook%2C%20for%20example%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3D'OtherWorkbook.xlsx'!SomeName%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

2 Replies

@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!