386,549 questions

Sort by: Updated
Updated Created Answers
1 answer

Calcualte Sum(Price) Ignoring one level

I need to create a measure which will group by vendorname and account name and pick max price and sum price at vendor level and account level ignore subaccount level. Create Derived table as shown in excel and do sum of price on derived table …

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,290 questions
asked 2020-08-27T00:08:14.97+00:00
Ra 1 Reputation point
commented 2020-09-01T09:07:51.767+00:00
Lukas Yu -MSFT 5,821 Reputation points
2 answers

Powerpoint 2016 does not display date and figures correctly

I work in a company. We use Office Pro Plus 2016. Many users complaint that when opening a powerpoint file which includes a chart, the date under the chart is not displayed correctly. For e.g: Instead of showing Jun-19, it shows some symbol. What…

Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,175 questions
asked 2020-08-18T18:24:47.12+00:00
Darsen 1 Reputation point
commented 2020-09-01T09:07:47.29+00:00
Emi Zhang-MSFT 25,621 Reputation points Microsoft Vendor
2 answers

What is the exact condition to consider a VM up in Azure Site Recovery

Azure Site Recovery offers groups in a recovery plan to control the order how the virtual machines are powered on. For exmaple, the database machines can be started before the VMs with the applications are comming up. I tried to find information about…

Azure Site Recovery
Azure Site Recovery
An Azure native disaster recovery service. Previously known as Microsoft Azure Hyper-V Recovery Manager.
718 questions
asked 2020-08-28T18:08:33.867+00:00
Peter Szabo 1 Reputation point
commented 2020-09-01T09:07:40.033+00:00
SadiqhAhmed-MSFT 46,206 Reputation points Microsoft Employee
1 answer

Chart is resizing when updating pivot table

Dear sir or madam, I created a pivot table 1 and pivot chart (Chart is related to another pivot table 2) on the same sheet. When I update the pivot table by changing filters, the size of the chart does not stay the same. Properties Chart: …

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,726 questions
asked 2020-08-10T14:08:28.083+00:00
Bogert Marco 1 Reputation point
commented 2020-09-01T09:07:26.907+00:00
Emi Zhang-MSFT 25,621 Reputation points Microsoft Vendor
1 answer

Regarding Office 365 A3 plan

How do i avail this plan. I couldnt get any link wherein i can make payment to avail Office 365 A3 plan. Kindly help me for the same

Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,175 questions
asked 2020-08-09T19:09:07.023+00:00
Hem Bhatt 1 Reputation point
commented 2020-09-01T09:05:18.17+00:00
Emi Zhang-MSFT 25,621 Reputation points Microsoft Vendor
2 answers

use visio in Office 365 Web

I am using GoDaddy Office 365 and I am my company admin. I have just subscribed trial license for Visio plan 1 and received "Get Started" email. But I cannot see Visio in my Office 365 web. Can you please help?

Visio Management
Visio Management
Visio: A family of Microsoft products used to create diagrams and vector graphics.Management: The act or process of organizing, handling, directing or controlling something.
255 questions
asked 2020-08-26T13:02:00.827+00:00
Alva Wai 1 Reputation point
commented 2020-09-01T09:03:42.86+00:00
Emi Zhang-MSFT 25,621 Reputation points Microsoft Vendor
2 answers

Tabs in Excel seem to stick to mouse pointer and will behave as if the user wants to move them.

I've had 2 users now complain that when they are using Excel (Online or Desktop), when they are clicking thru tabs in a workbook, the tab "sticks" to the mouse and starts to move the sheet. Its not something they are intending on doing nor is…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,726 questions
asked 2020-08-03T15:00:14.057+00:00
Vince Fletcher 1 Reputation point
commented 2020-09-01T09:03:33.3+00:00
Emi Zhang-MSFT 25,621 Reputation points Microsoft Vendor
1 answer

Readiness Toolkit Kit SQL report Crash

Hi, I explain my problem. I scan the servers in my company with the readiness toolkit but after a while the readiness hangs, does nothing and does not consume resources. Have you ever had this problem? Thank you !

Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,175 questions
asked 2020-08-13T12:31:35.323+00:00
LAINAY Quentin 1 Reputation point
commented 2020-09-01T09:02:45.047+00:00
Emi Zhang-MSFT 25,621 Reputation points Microsoft Vendor
2 answers

Blank existing word documents after update

Hi there, I updated my microsoft word and now when I open a preexisting word document, the document is blank. When I open a new document I am not able to type. Please help! Thanks very much, Julia

Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
933 questions
asked 2020-08-11T14:57:42.437+00:00
Julia Kellam 1 Reputation point
commented 2020-09-01T09:02:32.423+00:00
Emi Zhang-MSFT 25,621 Reputation points Microsoft Vendor
1 answer

error message on microsoft word

what does this error message mean -"you can't make this change because the selection is locked"

Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
933 questions
asked 2020-08-19T11:05:31.847+00:00
ras nnamdi 21 Reputation points
commented 2020-09-01T09:01:37.337+00:00
Emi Zhang-MSFT 25,621 Reputation points Microsoft Vendor
1 answer

Filtrar datos en excel con una lista de elementos en otra hoja.

Quiero filtrar una lista de datos usando una lista de elementos que esta en otra hoja. Ejemplo En hoja 1: Columna A. tengo una lista de códigos de 5 dígitos. En 1,000 filas. En hoja 2. Columna A: tengo otra lista de códigos de 5 dígitos. En una…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,726 questions
asked 2020-08-13T16:37:17.04+00:00
Brandon Josue Suchite Rodriguez 1 Reputation point
commented 2020-09-01T09:00:21.753+00:00
Emi Zhang-MSFT 25,621 Reputation points Microsoft Vendor
2 answers

Transferred the storage account - Now I do not see the storage account in source or targetted account.

I have transferred the storage account from my source account to target account. But later I learnt that you are not supposed to transfer the storage account, rather create a new storage account in target account and transfer all the files. Now the…

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,224 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,920 questions
asked 2020-08-19T14:30:10.387+00:00
Srinivasa Senapathi 1 Reputation point
commented 2020-09-01T08:59:47.147+00:00
Sumarigo-MSFT 47,021 Reputation points Microsoft Employee
1 answer

Excel File not Autorecovered

I was working on a academic calendar template and my laptop auto-restarted (even though the settings dictate that it should not auto-restart) and my workbook was lost. It is not in unsaved recovered workbooks. I was working on it completely offline. Is…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,726 questions
asked 2020-08-05T17:56:20.84+00:00
Sterling Lewis 1 Reputation point
commented 2020-09-01T08:59:27.717+00:00
Emi Zhang-MSFT 25,621 Reputation points Microsoft Vendor
1 answer

Requirement

I bought Microsoft 365, but this is not in my account. Thanks

Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,175 questions
asked 2020-08-01T15:52:07.95+00:00
GERMAN RAUL ALVAREZ BUITRAGO 1 Reputation point
commented 2020-09-01T08:54:58.01+00:00
Emi Zhang-MSFT 25,621 Reputation points Microsoft Vendor
6 answers One of the answers was accepted by the question author.

How to get missing parts on trade code table and that exist on table #parts and #search data?

I work on SQL server 2012 I need to count missing rows Part id that exist on table #parts and not exist on table #tradecode create table #searchdata ( plid int, codetypeid int ) insert into #searchdata (plid,codetypeid) values …

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,656 questions
asked 2020-08-31T01:39:54.81+00:00
ahmed salah 3,216 Reputation points
accepted 2020-09-01T08:35:01.4+00:00
ahmed salah 3,216 Reputation points
2 answers

How to get Quick Notes from OneNote on Desktop?

I'm using OneNote 2016 in Windows 10 Enterprise When I create a Quick Note (New Quick Note, or Windows + N), everything is fine: OneNote puts it on my desktop and I can move it around at will. However, once I close OneNote and/or shutdown my computer,…

Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,175 questions
asked 2020-08-06T15:50:59.313+00:00
imicrokallol 1 Reputation point
commented 2020-09-01T08:25:25.88+00:00
Emi Zhang-MSFT 25,621 Reputation points Microsoft Vendor
1 answer

Cannot insert Excel in Word

When adding an Excel object in Word, it failed and getting the error something like you need to install Excel app. But I do have already installed the Excel app! Here are my steps: Open the Word document where Excel spreadsheet has been placed. …

Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
933 questions
asked 2020-08-20T04:04:00.257+00:00
Idrish Khan 66 Reputation points
commented 2020-09-01T08:22:46.657+00:00
Emi Zhang-MSFT 25,621 Reputation points Microsoft Vendor
2 answers

Why does OneNote 2019 not sychronize via https any more?

OneNote 2019 does not synchronize via https any more. OneNote 2010 worked fine. How do I make it synchronize again?

Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,175 questions
asked 2020-08-18T13:33:53.36+00:00
OneNoteDoesntSync 1 Reputation point
commented 2020-09-01T08:21:58.1+00:00
Emi Zhang-MSFT 25,621 Reputation points Microsoft Vendor
2 answers

Office 365 Desktop programs deactivate themselves

Hello, So, we have those Office365 licenses where we can activate up to 10 machines per account. That means that these license accounts stay signed in on every single workstation that we activate. After the user has restarted Office programs a couple…

Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,175 questions
asked 2020-08-03T06:49:28.647+00:00
Veiko 1 Reputation point
commented 2020-09-01T08:20:33.7+00:00
Emi Zhang-MSFT 25,621 Reputation points Microsoft Vendor
1 answer

Mini Calendar and Date Picker

I'm looking for Mini Calendar and Date Picker plugin/add-in for office 365 . I could see only GET IT NOW option from the appsource.microsoft.com but i need the installation file or the source file. So that we will migrate our enterprise users to office…

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
39,712 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,726 questions
asked 2020-08-04T10:11:13.323+00:00
Rajasekar K 1 Reputation point
commented 2020-09-01T08:19:19.96+00:00
Emi Zhang-MSFT 25,621 Reputation points Microsoft Vendor