Remove all authors name from Excel

navic

Active Member
Joined
Jun 14, 2015
Messages
346
Office Version
  1. 2013
Platform
  1. Windows
At this link I did not get an answer to my question.
Maybe I'll have more luck in this forum.

It is common knowledge that with SaveAs in the (MS Office) window you have the option to enter the author before saving the Workbook.
Just type in one letter and Excel will list all the authors that begin with the letter (for all the files you once ran).

How to remove all these author names in Excel program (MS Office 2013)?
Is that possible?
Please help with explane or some web-link to instructions.
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Ok @Peter_SSs
Here is the screenshots.
If the forum moderator thinks that it is not allowed to post a screenshot here, please delete it.
btw: I don't know how to set 'ss' differently.
@RoryA
I don't want a few hundred unnecessary names on that list. That's why.
 
Upvote 0
[SOLVED] - Re: Remove all authors name from Excel

I had a B.S.O.D on my computer.
After reinstalling the system, I returned several Excel files to the "MyDocuments" folder.
The 'Windows Index Search Engine' indexed these few files and the author names appeared in the list.

Conclusion:
This meta data of all author names is in 'Windows Index Search Engine'
path: "C:\ProgramData\Microsoft\Search\Data\Applications\Windows\Windows.edb"
 
Last edited:
Upvote 0
Re: [SOLVED] - Re: Remove all authors name from Excel

I had a B.S.O.D on my computer.
After reinstalling the system, I returned several Excel files to the "MyDocuments" folder.
The 'Windows Index Search Engine' indexed these few files and the author names appeared in the list.

Conclusion:
This meta data of all author names is in 'Windows Index Search Engine'
path: "C:\ProgramData\Microsoft\Search\Data\Applications\Windows\Windows.edb"

Thanks for letting us know .

Here is a webpage that explains how to handle the Windows Search Service Database File via the UI.
https://windowsreport.com/windows-edb-file-huge-windows-10/
 
Last edited:
Upvote 0
Solution
Re: [SOLVED] - Re: Remove all authors name from Excel

Conclusion:
This meta data of all author names is in 'Windows Index Search Engine'
path: "C:\ProgramData\Microsoft\Search\Data\Applications\Windows\Windows.edb"
Here is a webpage that explains how to handle the Windows Search Service Database File via the UI.
https://windowsreport.com/windows-edb-file-huge-windows-10/
Thanks both. I have reduced my list (& file size) by about 94%. :beerchug:
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top