Remove all Author Names from Excel
If you are reading this tutorial, I believe that you are a computer user who frequently visits forums and downloads Excel, Word, or PowerPoint files to your computer (whether you are helping with some solutions or reading a document). Over time during the current year or more in the past years, you have opened a lot of files/documents.
Also, you noticed that when saving your own document (Save or Save As) in the "Authors:" field, you have more than one author in the list. In this list, there can be a hundred names, ie authors of Word documents, Excel Workbook or PowerPoint presentations. This list can grow to hundreds of names over time.
Also, in the "Tags: Add a tag" field there are a lot of sentences (phrases) that associate with the title of a document that you once opened.
Remove Author Tags from Excel, Word and PowerPoint
You've reached the point where you want to remove items (author names) from this list, but you don't know how?
As you continue reading this tutorial, find out how you can remove the list of document authors you once opened.
This list of author names is the result of "Windows Search Engine" (Indexing Options) when indexing specific folders. All files in the folders viewed by the "Windows Indexing Search Engine" will automatically add the collected names of the document authors found on the hard disk to this list.
Clear from memory, list of author tags in 'Save As' window
There are several things you can do to delete (clean) or remove the names of all Word document authors or Excel Workbooks, etc.
Open each file individually and remove the author via the "Inspect document" or "Incpect Workbook" option. So remove the name of the author of the document. Exclude the folder containing the files in question, from indexing, ie. do not allow Windows to index the respective folder. Reduce the "Windows.edb" file that contains a list of indexed files. (Delete and rebuild Windows.edb file)
Resize/reduce Windows.edb file
So in the first solution, you can open each file individually and remove the author's name (Required to delete and rebuild new 'Windows.edb' file).
Stop indexing (Start -> in Search field enter 'services' -> Stop item 'Windows Search')
In Windows Explorer, on 'View' tab turn ON "Show hidden files, folders and drives".
Delete file on the path ("C:\ProgramData\Microsoft\Search\Data\Applications\Windows\Windows.edb"). Go to Windows Explorer and delete 'Windows.edb' file (You must have administrator privileges).
Restart your PC -> Go to Start -> Control Panel -> Indexing Options,
Rebuild Windows.edb file.
On the 'Indexing Settings' tab and click on 'Advanced' button and click on the 'Rebuild' button. Confirm with OK button. Also in the "Advanced" dialog you can choose which files you do not want to index.
How to exclude a specific folder or files from indexing?
After rebuilding the 'Windows.edb' file, do the following.
- Go to Start -> Control Panel -> Indexing Options
- Click on 'Modify' button
- Uncheck certain folder
Windows Search Engine automatically indexes all files in set folders and collects specific data, authors, meta-tags, metadata and the like. The collected author data that created the open files is automatically displayed in the "Authors:" field as a list when you want to save a Workbook or Document.
So, to remove author names from this list, one of the above must be done, with the file "Windowws.edb".