Hi @Shaldon Datt,
Thanks for your trust and we are please to offer assistance.
To ensure we can thoroughly understand the issue and solve it more efficiently, we still need the following information:
- Does Document type refer to the default Content Type created in the list or your customized column? In SharePoint we don't have Document Type, we use Content Type to refer to the types of documents that can be added to the document library.
- Do you upload most of excel files to the document library or do you create them via the New button? These two ways will affect the automatic recognition of file types. Please let me know if you have both.
- How would you determine if the Document Type of file you uploaded is Process or Product? is the file name or is there some other attribute that determines this? This is important for automatic file type recognition.
Looking forward to receiving further information from you as your response is very important to the whole process of solving the problem.
If there is any question, please feel free to contact me.