SOLVED

Defined Names

%3CLINGO-SUB%20id%3D%22lingo-sub-2231688%22%20slang%3D%22en-US%22%3EDefined%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2231688%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EOver%20the%20years%20I%20have%20this%20accumulated%20names%20%26amp%3B%20those%20have%20reference%20to%20external%20files%20and%20I%20have%20to%20delete%20them%20one%20by%20one.%20Is%20there%20a%20way%20to%20purge%20all%20the%20names%20in%20bulk%3F%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2231688%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi,

Over the years I have this accumulated names & those have reference to external files and I have to delete them one by one. Is there a way to purge all the names in bulk?

Thank you,

 

5 Replies

@KiranKK On the Formula ribbon you find the Name Manager. Here you can select multiple names and delete them in one go. 

Thanks;
But I can't see Name Manager on the ribbon. I just see a Define Name, Create Name;
I am on MAcBookVersion (Office 360)
I meant Office365 License.
And in the Define Name box, I can delete them one by one. Tried various combinations for selecting multiple names but no success.
best response confirmed by KiranKK (New Contributor)
Solution

@KiranKK Aha! That's one of the features that are NOT available the Mac, unfortunately. Sorry.

Thank you. Much appreciated.
I just have to find a Windows Laptop then to get rid of this problem.