1,619 questions with Excel tags

Sort by: Updated
1 answer

Excel一直還原未存檔的部分會流失

使用EXCEL過程中,一次閃爍,便自動還原到未存檔 過程中所有未存檔資訊全未存檔,檔案並沒有關掉, 還原到剛從存檔中叫出來的樣子

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 questions
asked 2024-06-11T05:43:44.14+00:00
g water 0 Reputation points
answered 2024-06-11T07:12:09.7966667+00:00
Emi Zhang-MSFT 23,116 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Require sample data sets for better practice

Hi Team, I am requesting that you please provide the sample data sets to experience real understanding and gain quality knowledge. I am learning to be a Power BI data analyst. Please guide me to where I can download the data samples to practice and…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 questions
asked 2024-05-03T06:41:10.28+00:00
VenkataRamiReddy Pulikhandam 20 Reputation points
commented 2024-06-11T03:39:55.1933333+00:00
VenkataRamiReddy Pulikhandam 20 Reputation points
1 answer

My admin-managed Excel Office.js add-in is not appearing on iPad

Hi there, I've developed an Office.js excel add-in which has recently been deployed by my organisation through Integrated Apps. The add-in works perfectly on MacOS and through the browser, but I would like to use it on iPad. The 'admin-managed' add-in…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 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,657 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,046 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,671 questions
asked 2024-06-09T08:51:27.98+00:00
Freja Tara 0 Reputation points
answered 2024-06-10T03:01:59.96+00:00
Jiajing Hua-MFST 6,825 Reputation points Microsoft Vendor
1 answer

using golang msgraph-sdk-go to access user's workbook in their onedrive within the same organization

Hi, my goal is to create a background app that can access(read/write) one of the user's workbook(excel) in their onedrive within the same tenant (or organization. i am using the example app-only https://github.com/microsoftgraph/msgraph-training-go and…

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,123 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
912 questions
asked 2024-06-08T06:19:49.93+00:00
it-1048 0 Reputation points
answered 2024-06-10T02:42:15.2866667+00:00
Jiajing Hua-MFST 6,825 Reputation points Microsoft Vendor
3 answers

Excel connect to SQL Server using a different windows user name

hello, I am trying to connect to SQL Server in MS Excel using a different windows user credential other than current logged on windows user ID. using SQL Server database user name is not an option for me. Is there any function that can impersonate in…

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
10,978 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,113 questions
asked 2024-06-08T16:55:06.82+00:00
love to learn anything 0 Reputation points
answered 2024-06-10T02:27:33.9866667+00:00
love to learn anything 0 Reputation points
1 answer

EPM (SAP Add-in on Excel) reports entirely greyed out

Hello Microsoft Community, I have recently had the EPM Add-in (SAP connection) installed on my excel and I've found that my reports are entirely greyed out. Below are images showing my unusable report screen and my colleagues functioning screen for…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 questions
asked 2023-07-27T18:02:46.53+00:00
Nicholas Rynard 0 Reputation points
commented 2024-06-06T12:05:47.0266667+00:00
Emmanuel 0 Reputation points
1 answer

How to add Analyze data if already add

Hello, I already add-ins Analysis ToolPak and Analysis ToolPak - VBA but The Analysis Data tool does not appear on my Home. My Excel is Version 2405. How & What should I do? Please Help Me !!!

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 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,671 questions
asked 2024-06-05T14:40:32.4233333+00:00
Sofia 0 Reputation points
answered 2024-06-06T01:58:48.75+00:00
Emi Zhang-MSFT 23,116 Reputation points Microsoft Vendor
1 answer

How to upload add-in to excel store for review?

Hi, we are a new startup and have developed an add-in that we want to upload to the store for others to use in excel. I have been struggling four a couple weeks now to find out how to get this uploaded for review. I created a work account on Microsoft…

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.
4,135 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 questions
Windows 365 Business
asked 2024-05-15T01:48:39.0766667+00:00
Bjorn 0 Reputation points
edited the question 2024-06-06T01:40:35.1833333+00:00
Roy Li - MSFT 32,721 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

matching data issue in if formula

I am trying to compare two columns of data, which are formatted as dd/mm/yyyy to check they match, using a very simple IF formula: =IF(A2=B2,"match","not") Visually those which match are producing a "not" result, even though…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 questions
asked 2024-06-03T11:21:46.8933333+00:00
crib bar 781 Reputation points
accepted 2024-06-05T07:42:17.8466667+00:00
crib bar 781 Reputation points
0 answers

Not able to create multiple long running session for a single excel file using Microsoft graph workbook api.

We can create multiple long-running sessions for a single file using the Microsoft Workbook Create Session API, and the older sessions remain active for a short time. However, sometimes we receive an accepted (202) response when creating a new session,…

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,123 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
912 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,657 questions
asked 2024-06-04T20:44:03.6333333+00:00
Hari 6 Reputation points
edited the question 2024-06-05T07:39:03.0933333+00:00
Jiajing Hua-MFST 6,825 Reputation points Microsoft Vendor
0 answers

Create Outlook Subfolder and Rules via Excel Macro

Can one from an Excel macro auto-create Outlook Subfolders and Rules (associated with Subfolder). I know one can create emails via VBA / Macro

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 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,657 questions
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.
5,002 questions
asked 2024-06-04T14:09:00.6+00:00
Rob Walker 0 Reputation points
edited the question 2024-06-05T01:55:01.09+00:00
Faery Fu-MSFT 17,901 Reputation points Microsoft Vendor
2 answers

FileOpenUserUnauthorized error for excel API

Hi, I hope you are doing well. I am exploring Microsoft Graph Explorer for excel API and testing get worksheets in workbook endpoint. Although I have provided correct drive-item-id , I'm keep getting following error. { "error": { …

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,123 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 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,657 questions
asked 2024-03-20T10:15:33.05+00:00
kishan parmar 0 Reputation points
commented 2024-06-04T22:12:44.94+00:00
Abhishek 10 Reputation points
1 answer

Writing a Comparison function for Excel Visual Basic

I'm new to Visual basic and I'm currently trying to write a simple piece of code to Compare value of the cell in 2 different columns. If the values are the same, then I want to fill in cell Green in a third column, used for the comparison result. If the…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 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,657 questions
asked 2024-06-03T17:00:13.3633333+00:00
bill nguyen 5 Reputation points
answered 2024-06-04T16:58:43.8366667+00:00
jerardocervantes-6575 0 Reputation points
0 answers

Remote Desktop Mobile (RD Client) on iPad not sending shift keyboard combos to Excel

The Microsoft Remote Desktop Mobile app (RD Client) on iPad does not send many keyboard combinations correctly to Excel. I am using an 10th generation iPad with a keyboard to connect to two PCs running Windows 11 Pro to run Excel. Whether I connect to…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 questions
Remote Desktop
Remote Desktop
A Microsoft app that connects remotely to computers and to virtual apps and desktops.
4,340 questions
asked 2023-10-01T15:27:59.77+00:00
LanguageGame-2976 20 Reputation points
commented 2024-06-04T16:43:37.69+00:00
Zbark007 0 Reputation points
1 answer One of the answers was accepted by the question author.

How to take information from a Form and transfer the data into a word document

I am trying to take answers from a Microsoft Form and transfer them into a Word document. I have done it with Google forms, sheets and docs using the autocrat extension but I need to be able to do this in Microsoft.

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
719 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 questions
asked 2024-06-04T00:09:40.5+00:00
Amanda Smith 20 Reputation points
commented 2024-06-04T12:41:36.3033333+00:00
Amanda Smith 20 Reputation points
0 answers

Creating Excel with EPPlus: Set Column Widths in Pixels and Add Logo

Hello Friends; I have a question for you, I want to pull the data according to id and process it with excell, I even want to add a logo but I couldn't do it somehow, the thing is that I actually want to give the size to the columns and add a logo, but…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,306 questions
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,383 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 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,657 questions
asked 2024-06-03T15:08:17.0233333+00:00
kadir 60 Reputation points
edited the question 2024-06-04T00:57:45.2766667+00:00
Emi Zhang-MSFT 23,116 Reputation points Microsoft Vendor
5 answers

Error when looping through Access queries from Excel - "Too many client tasks"

I have a workbook that has many MS Query connections to an Access database. The workbook has been working great for years, but recently it stopped working after the 64th refresh. First I get a dialogue "Select data source", where MS Access…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 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,657 questions
asked 2023-03-13T17:02:17.0566667+00:00
Scott Conser 15 Reputation points
answered 2024-06-03T20:47:52.1566667+00:00
Green 0 Reputation points
1 answer

How do I create an excel file for csv export

How do I create an excel file so that it can be converted to a csv file to be exported into quickbooks online

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,408 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 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,671 questions
asked 2024-06-03T19:04:49.7833333+00:00
Mills Judy E 0 Reputation points
answered 2024-06-03T19:09:00.55+00:00
Olaf Helper 42,571 Reputation points
2 answers One of the answers was accepted by the question author.

MSQuery is has gone from GetData From Other Sources in Microsoft 365 Excel

I have been using MS Query MSQRY32.exe to access data in a 32 bit database using 32 bit DSNs for 30 years. Today I find that MSQuery has been removed from Excel-GetData-From OtherSources. MSQRY32.exe works if I run it directly. It is simply missing from…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 questions
asked 2024-03-30T04:11:32.3233333+00:00
Roger Lewis 40 Reputation points
commented 2024-06-03T17:32:12.7233333+00:00
Greg Devine 0 Reputation points
3 answers

Excel file with view permission won't open in desktop app got you don't have permission to open this file

Hi team, We granted a user view permission to an excel file. The user can open the Excel file from the web but encounters a "You don't have permission to open this file" error when trying to open it from the desktop app. Thank you for your help

Microsoft Exchange Online
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 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,671 questions
asked 2023-10-16T18:53:34.3966667+00:00
J-3804 1,561 Reputation points
edited an answer 2024-06-03T04:10:49.06+00:00
Sal 0 Reputation points