Skip to Content

Microsoft Will Block Excel XLL Add-ins from the Internet

Starting in March, Microsoft will block XLL files coming from the Internet in Office Excel. In its Microsoft 365 roadmap, Microsoft writes that it is making this change “to combat the increasing number of malware attacks in recent months.” Note Nice to see Microsoft continuing its quest to block common malware delivery methods. XLL files …

Read More about Microsoft Will Block Excel XLL Add-ins from the Internet

Solved: How do I sort data imported from Wikipedia using Microsoft Excel?

Problem Microsoft Excel offers the capability to import usable data from a Wikipedia web page. For example, the data on the state of Ohio can be imported from the following link: https://en.wikipedia.org/wiki/List_of_counties_in_Ohio The import process completed successfully. The imported table of data appears to be satisfactory; however, when attempting to sort the data, the process …

Read More about Solved: How do I sort data imported from Wikipedia using Microsoft Excel?

Solved: What is the function to create unique list of numbers that appear two or more times in Microsoft Excel?

Problem The formula in cell M5 creates unique list of numbers regardless of how many times they appear. The numbers that appears two or more times should show above those starting in cell M4 going across not down. I try to use the following formula but keep getting errors: =IFERROR(INDEX(B$2:F$11,MATCH(1,INDEX(((COUNTIF(L2:L$2,B$2:F$11)=0)*(COUNTIF(B$2:F$11,B$2:F$11)>=2)),),0)),””) How do I create a …

Read More about Solved: What is the function to create unique list of numbers that appear two or more times in Microsoft Excel?

MC400957: Recent Changes to Word, Excel, and PowerPoint integration in Teams

Word, Excel, and PowerPoint (WXP) are now available as Teams Personal Apps. There are no changes to the existing file open behavior for Word, Excel, and PowerPoint in Teams, however there are new abilities that the WXP Personal Apps can provide. Additionally, this change comes with a number of UX improvements to the Office ribbon …

Read More about MC400957: Recent Changes to Word, Excel, and PowerPoint integration in Teams

MC393822: Microsoft Purview Information Protection: Sensitivity labels now apply to modified documents (WXP on PC and Mac)

Coming soon to public preview, default labeling policies can be applied to any supported document that a user edits, not just a new document. This update applies to Word, Excel, and PowerPoint documents on PC and Mac platforms. This message is associated with Microsoft 365 Roadmap ID 93209. Users with default labeling policies will support …

Read More about MC393822: Microsoft Purview Information Protection: Sensitivity labels now apply to modified documents (WXP on PC and Mac)
Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

This site depends on revenue from ad impressions to survive. If you find this site valuable, please consider disabling your ad blocker.