Change the source data for a PivotTable - Microsoft Support
If your connection is not listed in the Existing Connections dialog box, click Browse for More, and then look for the data source you want to connect to in the Select Data Source dialog box. Click New Source if appropriate, and follow the steps in the Data Connection Wizard, and then return to the Select Data Source dialog box.. If your PivotTable is based on a connection to a range or table ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2019, Excel 2016, Excel 2013
Automatically run a macro when opening a workbook - Microsoft Support
In the VBA Project Explorer on the left hand side, expand the VBA Project folder for your workbook, then double-click the ThisWorkbook module.If you don't see the Project Explorer, you can go to View > Project Explorer, or press Ctrl+R.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel 2013
在 Windows 中将 Wi-Fi 网络设置为公共或专用网络 - Microsoft 支持
首次连接到Windows 11中的Wi-Fi网络时,默认设置为公共网络。 这是 建议 的设置。 但是,可以根据网络和要执行的操作将其设置为公共或专用:
Stay up to date with news and interests - Microsoft Support
The taskbar can display the temperature in Celsius (°C) or Fahrenheit (°F). To switch between these two units, select the weather icon on the taskbar, select the Edit location and unit icon on the weather card, select Celsius or Fahrenheit on the weather, and select Save. News and interests is supported in any taskbar orientation.
如何使用电脑健康状况检查应用 - Microsoft 支持
注意: 如果设备上发现兼容性问题会中断使用 Windows 11 的体验,我们会暂时延迟升级,直到问题得到解决。兼容性保障措施有助于确保在升级时获得最佳体验,并且当关键应用或驱动程序尚不兼容时,工作效率不会中断。
在 Windows 10 中修复显示模糊的应用 - Microsoft 支持
若要了解 Windows 是否可以解决该问题,请关闭在你的主显示器上显示模糊的桌面应用,然后再次打开它。 如果应用仍然显示模糊,你可以尝试为该应用使用不同的高 DPI 兼容性设置,而不是 让 Windows 尝试修复应用,使其不模糊 设置。 有关如何执行此操作的详细信息,请参阅使旧版程序与此版本的 ...
Create a team site in SharePoint - Microsoft Support
Notes: If your plan is to associate the new team site with a SharePoint hub site, you can streamline the process by first navigating to the hub site and clicking the Create site link in the top right corner there. The new team site will automatically be associated with that hub site. If you don't see the + Create site link, self-service site creation may be disabled in SharePoint.
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, Microsoft 365 admin
获取 Windows 中的经典免费 Solitaire 游戏 - Microsoft 支持
喜欢早期 Windows 版本中的免费 Solitaire 游戏吗?我们已将它们全部打包在一个便利的应用中,即 Microsoft Solitaire Collection。
输入 Office 产品密钥的位置 - Microsoft 支持
步骤 1:转到 www.microsoftstore.com 并使用用于购买 Office 的 Microsoft 帐户登录(右上角)。. 步骤 2:登录后,在右上角选择姓名,然后选择“订单历史记录”。. 步骤 3:找到 Office 一次性购买或单独的 Office 应用,然后选择“安装 Office”,查看产品密钥(此操作不会安装 Office)。
Applies To: Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Office 2016, Microsoft 365 for home, Office.com
在 Microsoft Edge 中查看 Cookie - Microsoft 支持
获取有关如何在 Microsoft Edge 中查看 Cookie 的步骤。