1,685 questions with Excel Management tags

Sort by: Updated
1 answer

How to add DSN to Microsoft Excel to connect to MongoDB database?

I am trying to connect MongoDB database in Excel through BI Connector. Following are the things I have setup. Installed BI connector tool. Installed iODBC and ODBC drivers for my current MacOS version. I have mongsqld running in local. It shows the…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 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,685 questions
asked 2024-03-19T09:45:39.9233333+00:00
Sagar Gopale 0 Reputation points
commented 2024-03-29T06:42:08.9133333+00:00
Jiajing Hua-MFST 7,315 Reputation points Microsoft Vendor
4 answers

My Slicers are not visible in excel office 365 on my sharepoint site.

My slicers are on the excel file however, when I access it on sharepoint it seems to disappear. How can I fix 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,685 questions
asked 2023-04-19T02:22:47.5133333+00:00
Herman Theng 0 Reputation points
answered 2024-03-28T16:23:22.61+00:00
Russell, Lori J 0 Reputation points
2 answers

How to calculate duration of years in power query

I have to calculate duration between current year and the year of hire of employees. I have column set up for year of hire Currently I used formula in custom column 2023-[year of hire] how can I write a formula where I don’t have to update current…

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,070 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
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,058 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.
224 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,685 questions
asked 2023-02-02T20:34:52.83+00:00
Anitha 0 Reputation points
commented 2024-03-27T12:40:35.58+00:00
Marcus Mängel 0 Reputation points
0 answers

Issue with Excel Add-In Code: Timeout Error

Our Excel add-in code is now getting a timeout error while updating cells in sheets exceeding 3500 rows. Despite smooth operation before, this issue has surfaced suddenly. We are investigating the root cause and working towards resolving it to restore…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 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,685 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,685 questions
asked 2024-03-27T06:32:12.9166667+00:00
Nirogini Albertjanstin 0 Reputation points
edited the question 2024-03-27T06:57:59.0333333+00:00
Jiajing Hua-MFST 7,315 Reputation points Microsoft Vendor
1 answer

How do i enable share workbook button on excel 365?

Hi, Please help The share workbook button on excel is greyed out, please advise on how to resolve this? Excel 365

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,685 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,685 questions
asked 2021-11-11T09:47:11.93+00:00
Humble 6 Reputation points
commented 2024-03-22T17:52:08.5066667+00:00
Williams 0 Reputation points
1 answer

Uso Excel para trabajar. Hoy me salió un cartel que dice "Protocolhandler.exe: la ejecución de código no puede continuar porque no se encontró MSVCP140_ATOMIC_WAIT.dll" ¿Cómo puedo solucionarl?

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,685 questions
asked 2024-03-20T20:10:55.32+00:00
Lucia Santillan 0 Reputation points
answered 2024-03-21T02:28:00.7533333+00:00
Emi Zhang-MSFT 23,351 Reputation points Microsoft Vendor
1 answer

Excel Data Analysis Error

I am using Microsoft 365 App (Enterprise) as a student (via a university e-mail address). I need to use Data Analysis, so I followed the 'load data analysis' at the Microsoft community. And Data Analysis was showed up on the 'data' tap. But when I…

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,685 questions
asked 2021-05-11T07:59:57.383+00:00
JY 6 Reputation points
commented 2024-03-20T14:50:51.02+00:00
AndyChips 111 Reputation points
1 answer

How to Fix Analyze Data Error in Excel?

Hello, I currently have issues with Analyze Data. Even though the Analyze Data option shows up on the ribbon, I am unable to use it because "it isn't set up properly." I have tried repairing Microsoft Office, repairing Excel, clicking removing…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 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,685 questions
asked 2024-01-22T08:09:12.0466667+00:00
Roshaan 10 Reputation points
commented 2024-03-20T14:47:18.36+00:00
AndyChips 111 Reputation points
2 answers

How to Change ribbon color?

How to change ribbon and tool bar color from white to black and worksheet color from black to white? New Laptop with Windows 11 Pro. Installed Office Pro 2019. Old Laptop with Windoes 10 and Office Pro 2019 has Ribbon and Tool Bar in Blackand Worksheet…

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,685 questions
asked 2023-04-03T17:18:36.2566667+00:00
BW PC 0 Reputation points
commented 2024-03-20T05:52:02.9666667+00:00
May Heng 0 Reputation points
1 answer One of the answers was accepted by the question author.

Many spread sheets results consolidated into a Master Sheet

I have a Master Spreadsheet and other spreadsheets into teams. I want to consolidate the information from the teams spreadsheets into the Master Spreadsheet.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 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,685 questions
asked 2024-03-12T14:28:56.35+00:00
Robin Smith 20 Reputation points
accepted 2024-03-19T14:35:36+00:00
Robin Smith 20 Reputation points
2 answers One of the answers was accepted by the question author.

How do I configure Azure Table storage to authenticate with user entra ID creds?

Hello. I have a project where I have been tasked to store some simple data in Azure Table storage and then have our users query it via Excel. But in Excel when you go to Get Data > From Azure > From Azure Table Storage and then provide the…

Azure Table Storage
Azure Table Storage
An Azure service that stores structured NoSQL data in the cloud.
162 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,685 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,360 questions
asked 2024-03-14T16:03:57.77+00:00
Fabio Carvalho 20 Reputation points
commented 2024-03-18T18:47:54.19+00:00
Fabio Carvalho 20 Reputation points
1 answer

Using pivot table grand totals for a row is not showing in excel

Grand total for a column is showing but not for rows using pivot table. Troubleshooting :have tested on a new machine , uninstall / reinstall office, Tested on web app same result , tested with a new file as well, it's a multiple user issue

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,685 questions
asked 2023-08-25T14:01:56.22+00:00
Gemini 5 Reputation points
commented 2024-03-18T14:14:54.11+00:00
Andrea Romero 0 Reputation points
2 answers

How to prevent Moduls to be automatically added when switching from Excel do VBA Editor with <Alt>F11

Hello When opening Excel and switching from Excel to VBA Editor with <Alt> F11 the following happens: PC 1: A Module is automatically added to the active workbook PC 2 and PC 3: Nothing happens Why does this happen and how can the automatic…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 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,685 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,685 questions
asked 2024-03-17T14:28:46.34+00:00
Jürgen Brändle 0 Reputation points
answered 2024-03-18T09:42:38.0233333+00:00
Jürgen Brändle 0 Reputation points
4 answers

READ-ONLY We opened this workbook read-only from the server WARNING

What might be the reason (or is it by design) that if we open Excel Files from our on-premises SharePoint 2019 we get this waring ribbon saying "READ-ONLY We opened this workbook read-only from the server --> Edit Workbook", while this 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,685 questions
asked 2020-07-29T14:39:10.177+00:00
Dieter Tontsch (GMail) 917 Reputation points
commented 2024-03-18T07:43:52.12+00:00
Pierre-Eric Mathez 0 Reputation points
5 answers

Excel slow to open second (or subsequent) file

I use MS Office Home & Business 2019 on Windows 10 PRO and my computer is quite fast (i7 processor, with 32gb RAM and and ssd drive). I have the following problem when opening Excel files (only when double clicking files from Windows Explorer): …

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,685 questions
asked 2020-12-21T20:11:33.347+00:00
Miha 31 Reputation points
commented 2024-03-17T22:24:45.5833333+00:00
mariano repila 0 Reputation points
1 answer

How to add February 29 (leap year day) to Pivot table?

I noticed that that data in my pivot table does not include February 29th in the table, which is the leap year day. I'm not sure how to add it into the table, since it is formatted correctly in the other sheet. How would I be able to add this? Thanks!

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 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,685 questions
asked 2024-03-08T15:33:49.8+00:00
Jessica 0 Reputation points
answered 2024-03-11T02:18:16.27+00:00
Emi Zhang-MSFT 23,351 Reputation points Microsoft Vendor
1 answer

Accéder sur Android à un fichier protégé par mot de passe sous windows 10

Bonjour, J'ai un fichier excel (version 2013) sous Windows 10 protégé par un mot de passe. Et qui et stocké sur mon Drive. Je veux pouvoir y accéder depuis mon telephone portable qui est sous Android. J'ai systématiquement une erreur "Impossible…

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,070 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,685 questions
asked 2023-04-20T15:52:57.5366667+00:00
pierre guinchard 0 Reputation points
commented 2024-03-09T16:29:55.1066667+00:00
Denis Belley P.HD 0 Reputation points
1 answer

Excel File Saved on OneDrive, Password Protected, Won't Let Me Get in Write Mode When Someone Else in READ

Hi, I have a password protected file saved on One-Drive. If someone else in my organization is in the file in READ-ONLY mode (they are NOT co-authoring) it won't allow me to get in the file in Write mode. This does not happen on a normal network drive,…

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,185 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,685 questions
asked 2024-03-07T20:46:43.5566667+00:00
jpd 0 Reputation points
answered 2024-03-08T07:28:40.7033333+00:00
Emi Zhang-MSFT 23,351 Reputation points Microsoft Vendor
16 answers

如何使用write这个用法

如何使用write这个用法不太懂 SD関連トランザクションコード一覧 販売管理 受注 T-code``名称``更新/照会``VA01``受注伝票登録``更新``VA02``受注変更``更新``VA03``受注照会``照会``VA05``受注伝票一覧``照会``V.02``不完全受注伝票一覧``照会``  分納契約 T-code``名称``更新/照会``VA31``分納契約の登録``更新``VA32``分納契約変更``更新``VA33``分納契約照会``照会``…

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,685 questions
asked 2023-07-02T09:52:42.9066667+00:00
aaaa 0 Reputation points
answered 2024-03-06T06:36:34.28+00:00
aaaa 0 Reputation points
5 answers

Doesn't show the AutoSave button

Hi........! Please answer me, My MS Excel doesn't show the AutoSave icon/ (on and off button) on the top of the left-hand corner. why so that? please give me a solution. My other MS Office products (MS Word, Powerpoint, etc.... are shown it). please sort…

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,980 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,685 questions
asked 2022-07-17T12:56:53.9+00:00
Amila Weerasekara 1 Reputation point
answered 2024-03-06T00:35:37.31+00:00
James 0 Reputation points