Monday, March 1, 2021

Known issues with office and windows 10

Last updated: February 2020

Note:  Microsoft 365 apps and services will not support Internet Explorer 11 starting August 17, 2021. Learn more. Please note that Internet Explorer 11 will remain a supported browser. Internet Explorer 11 is a component of the Windows operating system and follows the Lifecycle Policy for the product on which it is installed. 

We're working to fix the issues that may come up when using Office with Windows 10. In the meantime, please use the following workarounds to fix the problems.

Need more help?
If these workarounds don't resolve your problem, use the options at the bottom of this page for support.

Common issues

Issue

Solution

Office documents open slower after Windows 10 Fall Creators Update

In Windows 10 Fall Creators Update, the active Antivirus product can dynamically scan Office documents via the Antivirus API for Office when you open them. This helps the active Antivirus product to detect malicious documents that obfuscate malicious content by employing techniques like document encryption. This scanning occurs with all versions of Office documents and could result in a delay of up to 1 second per document.

Microsoft is investigating this issue and will post an update here once the issue is resolved. For more information on this new behavior, see Introduction to the Antivirus API Reference for Office.

Windows screen is flickering or flashing after logging in

You might see a flickering screen if you're running Microsoft 365, or Office 2016 build 16.0.7668.2066, which was released to a small group of customers between 1/25 and 1/30. As of 1/31, Microsoft 365 or Office 2016 build 16.0.7668.2074 is available and contains a fix.

To resolve this issue, please update Office to the newest version. Since the screen is flashing, you will need to do this using a command line. Please see this article for step by step instructions: Windows screen is flickering or flashing after logging in.

You can't find Office applications after Windows 10 upgrade

Windows 10 doesn't pin the Office apps to the Start menu or the Taskbar by default, but there are a few ways to find and open Office applications from the Start screen and taskbar in Windows 10.

For more information, see Can't find Office applications in Windows 10, Windows 8, or Windows 7?.

How to upgrade to Windows 10 on new devices that include Microsoft 365

If you just purchased a new device that includes Microsoft 365, we recommend installing Office before upgrading to Windows 10.

You can't print after upgrading to Windows 10

You may need to install new drivers for your printer. Also try running the printing troubleshooter to fix the issue.

For more information, see Fix printer problems.

You need help with licensing or product activation

See this article for more information: Unlicensed Product errors in Office.

After upgrading to Windows 10, Office apps display very large or very small on your monitor, or you have blurry text in your Office applications.

For more information and resolution, see Office apps appear the wrong size or blurry on external monitors.

Error messages

Issue

Solution

You get an error when opening Office 2013 documents after upgrading from Windows 7 to Windows 10, such as Word experienced an error trying to open the file or This file is corrupt and cannot be opened.

To resolve this issue, start one of your Office 2013 applications, like Word, and then select File > Account > Update Options > Update Now to install the latest updates.

For more information, see Errors opening Office files after upgrading from Windows 7 to Windows 10.

Outlook issues

Issue

Solution

After installing the Windows 10 Anniversary update, dragging emails to the file system or between folders does not work.

The issue affects all supported versions of Outlook 2010, 2013, and 2016. It may also happen with Mozilla Thunderbird.

Our engineering teams have investigated this issue, and are planning to release a fix in the near future. We'll post back here when we have more information.

After installing Windows 10, Business Contact Manager (BCM) may crash due to chart control issues during .Net registration.

BCM depends on the .NET framework for some of its features.

See Business Contact Manager crashes after upgrading to Windows 10 for more information and resolution.

When you click a hyperlink to a Web page in Outlook 2010 or Outlook 2007, you're prompted to specify Internet Explorer 11 as default browser.

For more information and resolution, see You are prompted to specify Internet Explorer when you click a link in Outlook 2010 or Outlook 2007.

Let us know how we can help

If these workarounds don't resolve your problem, do one of the following:

  • To leave us a comment, click the No box in the Was this information helpful? section below, and type your comment.

  • To talk to a support representative, click the Contact us button below.

  • To get help from the Office community, click Ask the community below.

  • To get more information about general Windows 10 Help and troubleshooting, see: Need help with Windows 10?.

Remove the underline from hyperlink text

When you want to include hyperlinks in your presentations, but do not want your audience to know that they are hyperlinks (until you are ready), you can remove the recognizable underline, yet still maintain the link.

Remove the underline from hyperlink text

  1. Right-click the hyperlink text, and then click Remove Hyperlink.

  2. On the Insert tab, in the Illustrations group, click Shapes, and then under Rectangles, click Rectangle.

  3. Drag to draw the rectangle so that it covers the hyperlink text that you want to hide.

  4. Right-click the rectangle, and then click Format Shape.

  5. In the Format Shape pane, do the following:

    1. Under Fill, click No fill.

    2. Under Line, click No line.

      The Format Shape pane

  6. Click the rectangle shape (but not the text inside of the shape), and then on the Insert tab, in the Links group, click Hyperlink.

  7. In the Address box, type the Web address, and then click OK.

  8. To test the hyperlink, at the bottom of the slide window, click Slide Show view. Slide Show view button.

  9. Click the text (rectangle) that contains the hyperlink.

  1. Right-click the hyperlink text, and then click Remove Hyperlink.

  2. On the Insert tab, in the Illustrations group, click Shapes, and then under Rectangles, click Rectangle.

  3. Drag to draw the rectangle so that it covers the hyperlink text that you want to hide.

  4. Right-click the rectangle, and then click Format Shape. In the Format Shape dialog box, do the following:

    1. Click Fill in the left pane, click Color in the right pane, and then click the color that matches the background of your presentation.

    2. Click Line Color in the left pane, click No line in the right pane, and then click Close.

  5. Right-click the rectangle, click Edit Text, and then type the text that you want to use for the hyperlink.

    Note: If you can't see the text as you type it, select the text. If you want to change the color or formatting of the text, select the text, and then on the Home tab, in the Font group, click the Dialog Box Launcher Icon image .

  6. Click the shape (but not the text inside of the shape), and then on the Insert tab, in the Links group, click Hyperlink.

  7. In the Address box, type the Web address, and then click OK.

  8. To test the hyperlink, in Slide Show view, click the rectangle that contains the hyperlink.

If you have feedback or suggestions about hyperlinks in PowerPoint, please post them here.

See also

Change the color of hyperlink text

Uninstall skype for business

Step 1: Stop Skype for Business from starting automatically

  1. In Skype for Business, choose the tools icon and Tools > Options.

    In Skype for Business, choose the Tool icon, then Tools >  Options

  2. Choose Personal, then uncheck Automatically start the app when I log on to Windows and Start the app in the foreground. Then choose OK.

    Choose Personal, then unselect the options to start automatically.

  3. Choose File > Exit.

    To exit Skype for Business, choose the gear icon, then File > Exit

Skype for Business is still on your computer, but you'll no longer see it.

Step 2: Remove Skype for Business from your computer

IMPORTANT: If you are using Microsoft 365Skype for Business, you can't delete it from your computer without also uninstalling the rest of the Office suite. This is because it's integrated with the other Office apps. The following instructions are for customers who have standalone versions of Skype for Business.

  1. Go to Control Panel > Programs > Programs and Features > Uninstall or change a program.

  2. Choose Skype for Business > Uninstall. If you don't see Skype for Business listed, then you're using a version that's integrated with other Microsoft 365 apps. The only way to uninstall it is to remove all of Office from your computer.

    In the Control Panel, choose Uninstall Programs, then choose Skype for Business

  3. At the Ready to uninstall? box, choose Uninstall.

  4. When it's done uninstalling, choose Close.

Remove Skype for Business from your registry

If the above instructions don't work for you, then another option is to disable it in your registry. For instructions, see this post in the Skype community: Completely Uninstall Skype for Business.

You can uninstall Skype for Business on Mac so you don't see it on your Dock in a few easy steps.

To uninstall Skype for Business on Mac

  1. To remove the Skype for Business icon Skype for Business launch icon from your Dock, sign out of Skype for Business on Mac.

  2. Close the Skype for Business on Mac sign in page.

  3. Press Control and click Skype for Business launch icon at the same time. Choose Quit.

  4. Open Finder > Applications. Scroll to Skype for Business. Drag and drop it into the Trash.

If this procedure doesn't solve the problem, use the more detailed procedure in How to do a clean uninstallation of Skype for Business on Mac.

See Also

Uninstall Skype for Business on a mobile device

Install Skype for Business

Block or remove a bot in teams

To stop a bot from participating in a one-on-one chat, first find the chat name in your chat list, then click More options More options button > Mute.

Bot menu showing Mute option

If you want to remove a bot entirely from a channel, find the channel name, then click More options More options button > Manage team. On the Apps tab, click Uninstall Delete button next to the name of the bot you want to remove.

Once you remove a bot, your teammates will no longer be able to @mention that bot in the team, and it will no longer be able to post to that team.

Sunday, February 28, 2021

Explore the files list in teams

Teams often work with a lot of files. The Files list makes it easier to locate the one you need.

Your browser does not support video.

Watch this video for a quick tour of the Files list.

Select Files Files button on the left side of Teams for quick access to all your files, arranged in the following views:

  • Recent lists every file you've recently viewed or edited.

    Tip: Another way to view your recent files is to enter /files in the command bar at the top of Teams.

  • Microsoft Teams contains all the documents that were recently created or edited in the channels that appear in your teams list.

  • Downloads shows all the files you've downloaded from Teams. This list is cleared each time you sign out of Teams.

  • Cloud storage shows the cloud storage services you've connected to Teams. Select a service to view your cloud files.

    List of folders and files in OneDrive

    From here, you can delete any personal file you've added to Teams, upload files, and create new files. Files added to cloud storage are private until you share them.

    By default, OneDrive cloud storage will be available. If your IT admin made it possible to add other cloud storage services, you'll see an Add cloud storage button at the bottom of the screen.

To view files in a specific chat or channel

  • Tap Files at the top of the conversation.

To view your recent files

  • Tap More Teams more icon  and then Files at the bottom right of the screen.
    From there you can also access your cloud storage files.

By default, OneDrive cloud storage will be available. Depending on policies set by your IT admin, you may be able to add other cloud storage services. For information on setting up other cloud storage services, see Add third-party apps to the Files app on iOS.

To view files in a specific chat or channel 

  • Tap Files at the top of the conversation.

To view your recent files

  • Tap More Teams more icon  and then Files at the bottom right of the screen.
    From there you can also access your cloud storage files.

By default, OneDrive cloud storage will be available. Depending on policies set by your IT admin, you may be able to connect other cloud storage services to Teams.

To learn more, see Files in Microsoft Teams.

Get geographic location data

To insert geographic data into Excel, you first convert text into the Geography data type. Then you can use another column to extract certain details relative to that data type, like Total population, or Time zone.

Note: The Geography data type is only available to Worldwide Multi-Tenant clients (standard Microsoft 365 accounts).

Use the Geography data type

  1. Type some text in cells. For example, type a country, state, province, territory, or city name into each cell.

  2. Then select the cells.

  3. Although it's not required, we recommend creating an Excel table. Later on, this will make extracting online information easier. To create a table, go to Insert > Table.

  4. With the cells still selected, go to the Data tab, and then click Geography.

  5. If Excel finds a match between the text in the cells, and our online sources, it will convert your text to the Geography data type. You'll know they're converted if they have this icon: Linked record icon for Geography

  6. Select one or more cells with the data type, and the Insert Data  button Add Column button will appear. Click that button, and then click a field name to extract more information. For example, pick Population.

  7. Click the Insert Data  button again to add more fields. If you're using a table, type a field name in the header row. For example, type Area in the header row and the Area column will appear with data.

Tips: 

  • To see all of the fields available, click the geography icon ( Linked record icon for Geography ) or select the cell and press Ctrl+Shift+F5.

  • If you see Question mark icon instead of an icon, then Excel is having a hard time matching your text with data in our online sources. Correct any spelling mistakes and when you press Enter, Excel will do its best to find matching information. Or, click Question mark icon and a selector pane will appear. Search for data using a keyword or two, choose the data you want, and then click Select.

  • You can also write formulas that reference data types.

See also

Poisson function

Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in 1 minute.

Syntax

POISSON(x,mean,cumulative)

X     is the number of events.

Mean     is the expected numeric value.

Cumulative     is a logical value that determines the form of the probability distribution returned. If cumulative is TRUE, POISSON returns the cumulative Poisson probability that the number of random events occurring will be between zero and x inclusive; if FALSE, it returns the Poisson probability mass function that the number of events occurring will be exactly x.

Remarks

  • If x is not an integer, it is truncated.

  • If x or mean is nonnumeric, POISSON returns the #VALUE! error value.

  • If x ≤ 0, POISSON returns the #NUM! error value.

  • If mean ≤ 0, POISSON returns the #NUM! error value.

  • POISSON is calculated as follows.

    For cumulative = FALSE:

    Equation

    For cumulative = TRUE:

    Equation

Example

X

Mean

Formula

Description (Result)

2

5

=POISSON([X],[Mean],TRUE)

Cumulative Poisson probability with the specified arguments (0.124652)

2

5

=POISSON([X],[Mean],FALSE)

Poisson probability mass function with the specified arguments (0.084224)