Microsoft Q&A

Excel

298 questions

A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.

Browse all Office tags

298 questions with Excel tags

Sort by: Updated
Updated Created Answers
0 answers

Issue with Sharepoint online viewer that opens incorrect version of file in Excel

Hello, I have an issue where a file I try to view using the online viewer in sharepoint for Excel wont work because the file is too large. I select to open it in Excel and it shows me a the file, but it appears to be from Jan instead of the most recent…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
298 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
178 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
6,476 questions
asked 2023-03-28T17:28:19.0366667+00:00
Marc S 0 Reputation points
1 answer One of the answers was accepted by the question author.

How to view Word/PowerPoint inline comments using Graph API?

I was wondering if it is possible to get comments for Wrod/PowerPoint files using the Graph API? https://learn.microsoft.com/en-us/graph/api/workbook-list-comments?view=graph-rest-1.0&tabs=http This works for Excel workbooks, but fails when I try on…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
298 questions
PowerPoint
PowerPoint
A family of Microsoft presentation graphics products that offer tools for creating presentations and adding graphic effects like multimedia objects and special effects with text.
44 questions
Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
144 questions
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
886 questions
asked 2023-03-27T12:35:48.9266667+00:00
Adz 231 Reputation points
commented 2023-03-28T12:31:59.8366667+00:00
Adz 231 Reputation points
0 answers

Allocate the "User" variable in the path of the folder where Excel is located

Guys, good afternoon! I just migrated to Office 365 with the entire server in the Cloud. The code below worked normally, as the main worksheet was on a physical server and the path of this file in Excel was fixed for any user who was logged on the…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
298 questions
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
232 questions
asked 2023-03-28T11:20:36.64+00:00
Leandro Amaral 0 Reputation points
1 answer

Conditional mail merge formatting: ONLY include blank cells

Hi, I've searched high and low for an answer to this - I'd be very grateful for your help. I'm creating a Word mail merge letter using data from an excel spreadsheet. I have information of over 400 people that I'm looking to email. I'm notifying these…

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
144 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
298 questions
asked 2023-03-27T15:37:26.6933333+00:00
Nina 0 Reputation points
answered 2023-03-28T08:26:17.1133333+00:00
Emi Zhang-MSFT 11,566 Reputation points Microsoft Vendor
1 answer

How can we know the number of licences

Proper way to confirm number of licenses

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
298 questions
asked 2023-03-28T01:32:56.1666667+00:00
Samir Jabba 0 Reputation points
answered 2023-03-28T08:21:34.7766667+00:00
Emily Hua-MSFT 23,781 Reputation points Microsoft Vendor
0 answers

How to filter a card-diagramm by klicking on the countries in the map?

Good morning, i have a problem with my card-diagram (map) in excel. I've got some slicers to visualize the diagramm in different colours etc. I can filter the shown countries in the map by klicking on the countries in the slicers. Now i want to…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
298 questions
Windows Maps
Windows Maps
A Microsoft app that provides voice navigation and turn-by-turn driving, transit, and walking directions.
194 questions
asked 2023-03-28T07:59:53.52+00:00
Rene Bluemke 0 Reputation points
1 answer

How to use pivoting table to do division?

Hi everyone, I need a little help here! Lets say below is a dataset for the study duration of classroom A, i want to find out how many words learned per hour. Thus, it supposed to be Words learned divide by study duration (hours) right? But the problem…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
298 questions
asked 2023-03-23T10:05:44.0833333+00:00
kain 0 Reputation points
commented 2023-03-28T07:44:58.9633333+00:00
Emily Hua-MSFT 23,781 Reputation points Microsoft Vendor
1 answer

When I close Excel, an empty Excel window opens again.

I recently upgraded from Excel 2007 to the 2021 version and since then, every time I use Excel and close it after saving, an empty Excel window automatically opens again. I have tried updating and reinstalling Excel, but the problem persists. I am…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
298 questions
asked 2023-03-21T00:05:31.69+00:00
재경 이 0 Reputation points
commented 2023-03-28T07:42:56.6133333+00:00
Emily Hua-MSFT 23,781 Reputation points Microsoft Vendor
1 answer

Pivot table field list won't show despite being selected

I'm unable to view the field list for a new or existing pivot table. I can toggle the Field List button on the ribbon on/off, however it never actually appears.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
298 questions
asked 2023-03-20T20:04:04.0833333+00:00
CR 0 Reputation points
commented 2023-03-28T07:42:19.4433333+00:00
Emily Hua-MSFT 23,781 Reputation points Microsoft Vendor
1 answer

Vlookup to ignore blanks and only return when there is a value

I have a pivot table that there is a sales lead in column B that I need associated with the invoice total line (col F). I have added helper text columns in D & E, and want to pull the lead over to the line with the TOTALS. When I use the following…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
298 questions
asked 2023-03-20T12:29:25.24+00:00
Kristene Couture 0 Reputation points
commented 2023-03-28T07:41:54.4033333+00:00
Emily Hua-MSFT 23,781 Reputation points Microsoft Vendor
1 answer

How to fix data analysis so it can run properly again?

"Automation error (Error 440)" is showing up once I select to run the data analysis add in. I have been able to run data analysis before on this computer. Additionally, I have added and unadded the data analysis add ins from the excel options.…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
298 questions
asked 2023-03-19T14:40:27.69+00:00
Jacob Bergin 0 Reputation points
commented 2023-03-28T07:40:54.57+00:00
Emily Hua-MSFT 23,781 Reputation points Microsoft Vendor
1 answer

Date Time format changes after saving

Hey All, I am needing an excel file to save my date in the following format dd:mm:yyyy hh:mm:ss. When I change the column to that format using "custom" it shows in the column correctly and in the formula. However, when I save the document and…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
298 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,364 questions
asked 2023-03-17T12:43:59.01+00:00
Kirby Baxter 0 Reputation points
commented 2023-03-28T07:36:59.58+00:00
Emily Hua-MSFT 23,781 Reputation points Microsoft Vendor
0 answers

How to put Office Excel to open a file in SharePoint

Hi, I am using Office365 client applications on the Win11 OS. When I access to our SharePoint website and clicks any of excel files, it will be launching an Excel online in Edge browser, my question was: How to get access to those excel files via…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
232 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
298 questions
Microsoft Office Online Server
Microsoft Office Online Server
Microsoft on-premises server product that runs Office Online. Previously known as Office Web Apps Server.
404 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
4,115 questions
asked 2023-03-28T07:23:57.67+00:00
LU Yajun 0 Reputation points
1 answer

Excel nie odpowiada podczas zamykania dokumentu.

Excel nie odpowiada podczas zamykania dokumentów. Zarówno tych wcześniej zapisanych jak i nowo utworzonych. Co ciekawe nawet po uruchomieniu pustego arkusza Excel i próbie zamknięcia dzieje się to samo. Excel nie odpowiada i nie chce się zamknąć.…

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
502 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
298 questions
asked 2023-03-23T09:42:33.61+00:00
Michał Pawłowski 0 Reputation points
commented 2023-03-28T07:20:29.7366667+00:00
Emily Hua-MSFT 23,781 Reputation points Microsoft Vendor
1 answer

_xlfn.ANCHORARRAY error mac

I have the exact same problem as this guy: https://answers.microsoft.com/en-us/msoffice/forum/all/xlfnanchorarray-error-mac-v1643/66183d4a-44c0-428b-b5fb-485cbf213a69but cannot find any good solution to this problem. When I use a temple in excel on my…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
298 questions
asked 2023-03-27T13:15:35.89+00:00
Jacob Olav Otnem Bergo 0 Reputation points
answered 2023-03-28T06:50:11.41+00:00
Emi Zhang-MSFT 11,566 Reputation points Microsoft Vendor
1 answer

How to display a map of locations in Excel?

We are using a system that provides periodic locations by person. Using OData, we can bring that information into Excel. There would be four columns: datetime, person, latitude, and longitude. What we would like to do is show on a map, the locations of a…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
298 questions
asked 2023-03-27T13:57:09.81+00:00
John Wiles 0 Reputation points
answered 2023-03-28T04:33:30.99+00:00
Emily Hua-MSFT 23,781 Reputation points Microsoft Vendor
0 answers

How to run a Macro with an Excel Script?

My workbook contains a Marco called "Start" I would like to create a script that runs the Macro "Start" so that I can control it from Power automate. I can not find te right command in ExcelScript (run?) Note : I work in an xlsm…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
298 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
517 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,197 questions
asked 2023-03-27T13:46:47.7933333+00:00
Thibault CHEVALIER 0 Reputation points
edited the question 2023-03-28T00:53:33.67+00:00
Emily Hua-MSFT 23,781 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

How to have excel macros working under Azure Active Directory Authentication in a normal .NET Web Application Project?

We have a .NET Web Application running on latest technology stack wherein it uses SQL Server in the back-end and MS Blazor in the front-end. Also some portion of front-end exist in excel since we are using some macros to accomplish functionalities like …

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
298 questions
Azure Active Directory External Identities
Azure Active Directory Domain Services
asked 2023-03-14T04:05:24.0133333+00:00
Ambar Ray 20 Reputation points
edited the question 2023-03-27T21:29:58.4966667+00:00
JamesTran-MSFT 27,836 Reputation points Microsoft Employee
0 answers

Pivot Table #DIV/0 error in field summary Column but not in lower level.

Hello, I am having issues with my pivot table #DIV/0 populating on my weekly summary, but it is not an issue on my daily summary. What would be some possible causes of this and how can I correct it?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
298 questions
asked 2023-03-23T21:13:57.0733333+00:00
Isaac 0 Reputation points
edited a comment 2023-03-27T18:50:02.76+00:00
Isaac 0 Reputation points
2 answers

"Excel Add-ins machine does not support". Desktop computer app add-in not supported?

Hello, I am unable to submit data via the add-in option on the desktop version. I had no issues on the laptop. The message I get is "could not load some objects because they are not available on this machine". I am using the cloud version of…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
298 questions
asked 2023-03-25T07:29:36.19+00:00
Iliana Nikleva 0 Reputation points
answered 2023-03-27T09:51:16.6033333+00:00
Emily Hua-MSFT 23,781 Reputation points Microsoft Vendor