1,641 questions with Excel Management tags

Sort by: Updated
Updated Created Answers
5 answers

merge excel files

How to merge several Excel file into one worksheet in Excel?

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,641 questions
asked 2021-04-23T11:50:20.727+00:00
Patrick Wu 1 Reputation point
commented 2024-04-27T01:37:46.6433333+00:00
lamhaocc 0 Reputation points
0 answers

Excel can't convert xml file to xml table when there's only one row

Hello, I get a response XML from a service. When the XML contains multiple rows of data it imports into Excel fine but if there is only one row of data the headers nothing imports. Both XML files are…

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,641 questions
asked 2024-04-26T15:27:46.35+00:00
loamylo 0 Reputation points
0 answers

formula in excel to simulate lunch and breaks

formula in excel to simulate lunch and breaks

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,641 questions
asked 2024-04-22T06:49:44.1733333+00:00
Harry Oliquiano 0 Reputation points
commented 2024-04-26T07:40:43.7366667+00:00
Jiajing Hua-MFST 4,675 Reputation points Microsoft Vendor
1 answer

Creating Forms with Dropdown options using Excel

I am creating a request form using Excel. I want to be able to allows users to select one of the options from the drop-down or fill in the necessary information. Can I create a drop down that allows users to select from the list or fill in relevant…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,464 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.
3,489 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,641 questions
asked 2024-04-25T15:13:49.79+00:00
Felicia B 0 Reputation points
commented 2024-04-25T16:35:12.1433333+00:00
Felicia B 0 Reputation points
3 answers One of the answers was accepted by the question author.

Excel File in Use - wrong user

Hi guys, There is an Excel file created by a user (say User_A). (This is the only file from many other Excel files that behaves this way.) Normally when an Excel file is already opened the next user can see who opened that file from a popup…

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,641 questions
asked 2021-01-11T21:16:09.927+00:00
Cloud_Geek_82 801 Reputation points
commented 2024-04-25T12:09:22.4466667+00:00
Fernando Silva 0 Reputation points
1 answer

How to write dynamic array references inside a XLOOKUP and FILTER functions

Dear community, I will appreciate your help, advice and support with the following: I have a master file with all of the residents contributions for maintenance and repairing on our house group. From this master file, I'm looking up for each resident…

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.
3,489 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,641 questions
asked 2024-04-15T19:56:36.43+00:00
Rafael Morales 0 Reputation points
edited the question 2024-04-22T06:54:53.62+00:00
Jiajing Hua-MFST 4,675 Reputation points Microsoft Vendor
0 answers

API for Microsoft Excel is not working properly.

Hey, I am connecting you on behalf of Pabbly Connect. Within our integration, we have set up an action event "List Worksheet" which is currently throwing an error and we are not able to use a list worksheet. Here is the URL for your…

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,592 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.
3,489 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,641 questions
asked 2024-04-18T11:41:46.9633333+00:00
Neeraj Agarwal 0 Reputation points
commented 2024-04-22T06:00:30.2333333+00:00
Neeraj Agarwal 0 Reputation points
2 answers One of the answers was accepted by the question author.

Can not type into cells of excel file embeded from OneDrive

Dear Team,I have generate embeded code that allow to type into cells. I see it OK in the PREVIEW mode. (Preview mode included in customizing embed code Screen) The image as…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,464 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
810 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,628 questions
OneDrive Management
OneDrive Management
OneDrive: A Microsoft file hosting and synchronization service.Management: The act or process of organizing, handling, directing or controlling something.
1,122 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,641 questions
asked 2024-03-21T02:29:06.85+00:00
Premium Premium 35 Reputation points
commented 2024-04-18T06:44:12.1533333+00:00
Maxence Svensson 0 Reputation points
2 answers

how to get rid of script error in excel web query

I am using ms excel 2016 standard and OS is windows 10. I have been trying to use web query feature in excel to download a data from a website but have been getting scripting error. how i can avoid that. Also i guess my excel tries to open the web page…

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,641 questions
asked 2024-04-14T10:53:21.63+00:00
Savitri K 0 Reputation points
answered 2024-04-17T06:35:05.67+00:00
Savitri K 0 Reputation points
22 answers

Microsoft should FIX - "Errors were detected while saving (filename)"

Microsoft must FIX this decade long bug with appears out of nowhere and has ruined a lot of months of work of my life. Please fix the below error message. It is even appearing in latest Office 2019. "Errors were detected while saving (filename).…

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,641 questions
asked 2020-07-27T18:53:59.793+00:00
Asha Kanta Sharma 81 Reputation points
commented 2024-04-15T11:25:14.98+00:00
Ulrik WS 0 Reputation points
0 answers

I would like to export all tracked changes in my excel sheet

I have an Excel spreadsheet in which I made changes and turned on track changes. I can do a 'Show changes', but I would like to export all those changes to a new Excel sheet. Do you have an code that can do that?

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
660 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,464 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.
3,489 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,641 questions
asked 2024-04-13T12:54:27.94+00:00
Sultana 10 Reputation points
edited the question 2024-04-15T08:10:06.39+00:00
Jiajing Hua-MFST 4,675 Reputation points Microsoft Vendor
6 answers

frequent error when refreshing pivot table

When refreshing a Pivot table that is created from another worksheet, I get: An unexpected error occurred (file'pcminorobjcoll.inl', line 109, function 'PCMinorObjectCollection[class PCProperty.class NameHashSupport]::SetNameAndUpdateCollection') This…

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,641 questions
asked 2021-05-10T19:42:09.177+00:00
Eric Brinsfield 1 Reputation point
commented 2024-04-15T07:37:21.71+00:00
Henry Phan 0 Reputation points
2 answers

Excel macro recording for formatting a comment in a cell not possible

I'm trying to record a macro in Excel while formatting a comment for a cell. But only the text content will be recorded. Changing of background color, pattern e.g. are not recorded. The button for stop recording is dimmed when I enter the dialogue box…

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,641 questions
asked 2024-04-11T16:21:28.02+00:00
Jürgen Schomann 0 Reputation points
commented 2024-04-12T19:02:35.7833333+00:00
Viorel 112.1K Reputation points
1 answer

How to fix Microsoft.NET Framework "Value Does not fall within the expected range" error

Hello, I have an Excel file linked with powerpoint for +50 graphs and tables. It was working fine until I linked the cell below: ="Average Deal Cycle is " & J3 & " Days" with some formatting, such as color and borders. Now,…

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,376 questions
PowerPoint Management
PowerPoint Management
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.Management: The act or process of organizing, handling, directing or controlling something.
221 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,641 questions
asked 2024-04-03T09:40:50.61+00:00
Murathan Akhan 0 Reputation points
commented 2024-04-11T13:01:32.6+00:00
Jiachen Li-MSFT 26,506 Reputation points Microsoft Vendor
6 answers

Can't interact with Excel because of hidden dialog box.

Hidden dialog box keeps Excel from operating properly. I've tried alt-tabbing the dialog does not show up. When I try to shut Excel down using the task manager since close it normaly I get a dialog box stating "You cannot close Microsft Exel…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,464 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,641 questions
asked 2023-01-15T16:07:05.61+00:00
John Wilk 20 Reputation points
commented 2024-04-09T15:03:17.34+00:00
Jonathan Cohen 0 Reputation points
2 answers

When creating a new excel sheet, how can some specific cells appear in another sheet?

Good day all, I need your help for a project please. Pls find the link if this can help: https://1drv.ms/x/s!AtYjpXHdhdJHmF9DcIIsgyPob3bk?e=PZvUW3 When creating sheet P.O No.1, we want to have the below cells to automatically appear in sheet P.O…

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.
3,788 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,464 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.
3,489 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,641 questions
asked 2024-04-03T04:44:36.5366667+00:00
Jacques Bouquet 0 Reputation points
commented 2024-04-08T17:26:51.13+00:00
Barry Schwarz 1,946 Reputation points
1 answer

Export scheduling poll results to an excel spreadsheet

I am scheduling a meeting using the scheduling poll for over 15 people and over 30 options. Is there a way to export the results to an excel spreadsheet (similar to the Doodle export function)?

Outlook Management
Outlook Management
Outlook: A family of Microsoft email and calendar products.Management: The act or process of organizing, handling, directing or controlling something.
4,887 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,641 questions
asked 2023-07-10T17:45:07.75+00:00
Jessica Dery 10 Reputation points
commented 2024-04-08T16:55:36.1766667+00:00
Constante, Rosa 5 Reputation points
0 answers

Programmatically read restricted excel file

I have a series of Excel's that are protected by the business. I have the required permissions to view the file manually however I would like to create a programmatic way to extract the data from these excels. I have tried using Python to read and…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,464 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.
3,489 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,641 questions
asked 2024-04-05T11:44:17.3133333+00:00
Rando 0 Reputation points
edited the question 2024-04-08T00:37:11.7866667+00:00
Emi Zhang-MSFT 21,856 Reputation points Microsoft Vendor
0 answers

Deleted question

Deleted question

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,641 questions
asked 2024-04-04T19:58:56.9433333+00:00
ExcelIntermed47 0 Reputation points
edited the question 2024-04-06T08:49:07.27+00:00
ExcelIntermed47 0 Reputation points
1 answer One of the answers was accepted by the question author.

Muita dificuldade de acesso ao Microsoft Authenticador

Preciso entrar no Microsoft Authenticador mas, após digitar a senha, o aplicativo pede para acessar o proprio aplicativo e digitar o código que se encotra lá, a mesma coisa ocorre quando seleciono outra maneira de entrada, ou seja, fico num looping…

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.
3,788 questions
Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
660 questions
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,303 questions
Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
5,496 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,641 questions
asked 2024-02-25T21:35:24.2766667+00:00
eliabner soriano 20 Reputation points
commented 2024-04-06T01:11:29.99+00:00
eliabner soriano 20 Reputation points