1,680 questions with Excel tags

Sort by: Updated
1 answer

why /me/drive/SharedWithMe Returns "value": []

I'm getting it: R R I'm getting it "error": { "code": "accessDenied", "message": "Access denied", "innerError": { "date":…

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,364 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
958 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,247 questions
asked 2023-01-18T19:29:09.71+00:00
Lucas Matheus Rodrigues Brum 0 Reputation points
commented 2023-02-08T06:08:47.3066667+00:00
RaytheonXie_MSFT 33,636 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Multi-conditional search returns non-duplicate values

Returns the non-repeating value of column A according to the date and name

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 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,688 questions
asked 2023-01-31T13:30:49.5366667+00:00
BABY_JOJO 241 Reputation points
accepted 2023-02-06T14:36:15.7366667+00:00
BABY_JOJO 241 Reputation points
1 answer

Power Query Contains in collum

Hello I wanted to make a function, in which, if the value of column 1 is inside column 2, show "yes" if not, show "No"

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 questions
asked 2023-02-03T17:32:22.4266667+00:00
Pedro Faria / DUX SAO 0 Reputation points
answered 2023-02-06T08:35:26.12+00:00
Emily Hua-MSFT 27,591 Reputation points
1 answer

How to fix excel student account credential?

Hi Unfortunately, I just disabled my student credential for excel. From managing device options I disabled it. Please help me with this. How can I fix this issue?

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,457 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 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,707 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,688 questions
asked 2023-01-19T07:04:53.72+00:00
Yeasin Arafat 0 Reputation points
edited the question 2023-02-06T07:38:48.8866667+00:00
Jayce Yang-MSFT 1,331 Reputation points Microsoft Vendor
2 answers

Is there any way to load wininet.dll using macros, scripts, or PowerShell??

Hi guys ! I use a couple of macros that handle files in SharePoint thru commands like "Dir" , "Save" , "open" etc. Many of these commands (Dir for instance) do not work if wininet.dll is not "loaded". In the…

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,147 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,247 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,300 questions
asked 2023-02-02T14:21:29.1933333+00:00
Marcelo Buarque (Nokia) 0 Reputation points
commented 2023-02-06T06:03:11.7733333+00:00
AllenXu-MSFT 18,051 Reputation points Microsoft Vendor
1 answer

The current .NET security policy prohibits C:\Users\...\File.xlsx from loading custom macros.

I am working on a project in Visual Studio Community 2022. The project is an Excel VSTO Workbook using Visual Basic (Target framework is .NET Framework 4.8). Up until yesterday everything was working fine, I could run and debug my project whenever I…

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,613 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,866 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 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,707 questions
asked 2023-01-19T01:59:19.6166667+00:00
Ricardo Freccero 1 Reputation point
answered 2023-02-03T19:42:40.97+00:00
Abraham Valencia 0 Reputation points
1 answer

1. i have an excel file which is called 20221226_Cash Flow_KA. 2. in this Excel file a query of CSV files is made by power query. These files are located in the folder current accounts. Accordingly, the worksheet that is output by the query is called Curr

i have an excel file which is called 20221226_Cash Flow_KA. in this Excel file a query of CSV files is made by power query. These files are located in the folder current accounts. Accordingly, the worksheet that is output by the query is called…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 questions
asked 2023-02-02T13:54:43.3166667+00:00
Andreas Giannaku 0 Reputation points
answered 2023-02-03T06:33:53.57+00:00
Emily Hua-MSFT 27,591 Reputation points
1 answer

Importing excel data to MS SQL using EPPlus

I am writing a C# code in .Net 6 to read data from excel and save them into the database. when reading the column with date/ date time value I realized that if the cell contains a time portion, Epplus will return the cell value as 9/1/2000 8:00:00 AM,…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 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,306 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,619 questions
asked 2023-02-03T02:31:52.5066667+00:00
Benjamin Chew 41 Reputation points
answered 2023-02-03T06:20:47.2766667+00:00
Olaf Helper 43,161 Reputation points
1 answer

Thousand Separator support for different region in Excel addin

Hi Team, - We are offering a Excel addin where user can upload local excel and save it to onedrive, The addin is available on office store. - In this Addin we are providing one feature where user can upload numbers in any region format(thousand…

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,364 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
958 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,707 questions
asked 2023-01-31T06:50:01.47+00:00
office 365 1 Reputation point
answered 2023-02-02T13:18:21.2533333+00:00
Shivam Dhiman 5,951 Reputation points
1 answer

Trying to Rescale images remotely in word from excel macro

For my company one of the processes is copying graphs from an Excel spreadsheet and pasting them into a word document. However, these graphs are pasted slightly too big and need to be descaled to 80% their original size. I'm trying to write a macro in…

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
746 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,659 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,707 questions
asked 2023-01-27T16:24:48.3666667+00:00
Archie Smith 0 Reputation points
commented 2023-02-02T08:06:06.4333333+00:00
Emi Zhang-MSFT 23,736 Reputation points Microsoft Vendor
1 answer

Hi Dears, How to check import operation error in power pivot excel?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 questions
asked 2023-01-29T18:40:08.5133333+00:00
San Lin 0 Reputation points
commented 2023-02-02T07:59:38.53+00:00
Emi Zhang-MSFT 23,736 Reputation points Microsoft Vendor
2 answers

Accessing Cheaper/Free Student Certifications

I work with students with disabilities and all are in technology classes working with Microsoft Applications. We are wanting to look at having some of them try for their certifications but cannot pay the $100 for each test knowing many may not be able to…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 questions
asked 2023-02-01T14:27:24.4366667+00:00
Richard, Kayla 0 Reputation points
answered 2023-02-02T03:08:32.35+00:00
Emily Hua-MSFT 27,591 Reputation points
1 answer One of the answers was accepted by the question author.

C# Office.Interop.Excel How do I loop through the AutoFilter'd returned rows?

I have created the following AutoFilter: excelRange = excelWorksheet.get_Range("G1"); excelRange.AutoFilter(Field: 7, Criteria1: "Part Number"); excelRange.AutoFilter(Field: 7, Criteria1: ">A*", Operator:…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,619 questions
asked 2023-01-30T17:01:16.05+00:00
Alvord, Timothy 236 Reputation points
accepted 2023-02-01T16:32:25.4333333+00:00
Alvord, Timothy 236 Reputation points
4 answers One of the answers was accepted by the question author.

Question about Dynamics Business Central & Excel

Hi- I am a beginner using Microsoft products and have been at my job 5 months. My boss gave me a new task which is to... using a an Excel master file we have which list every inventory item we have and the cost and pricing etc. All anyone know to do is…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 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,061 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,688 questions
asked 2023-01-11T21:41:38.91+00:00
Melissa Obrien 20 Reputation points
commented 2023-02-01T14:07:34.7233333+00:00
Melissa Obrien 20 Reputation points
0 answers

Getting ORA-12154 - TNS: could not resolve service name error in Excel 365

My client recently upgraded his Microsoft Office suite from 2016 to 365 on his workstation. I am working with a him on getting his spreadsheet that was created in Excel 2016 (32 bit) connecting to a Oracle database. He has no problem opening the…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 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,707 questions
asked 2023-01-31T16:49:10.96+00:00
Will Wong (MA) 5 Reputation points
edited the question 2023-02-01T06:19:17.25+00:00
Emily Hua-MSFT 27,591 Reputation points
2 answers

Can I save pivot table in compatibility mode?

I'm trying to save a pivot table and I see the file is in compatibility mode will that prevent me from saving the pivot table?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 questions
asked 2023-01-19T19:53:29.9733333+00:00
Dennis Bjorklund 0 Reputation points
commented 2023-02-01T02:23:23.6466667+00:00
Ceasar Chen_MSFT 4,391 Reputation points
1 answer

Where are located default preferences for Excel on MacOS?

Hi, I want to change some preferences used by default by Excel on MacOS, to be used for any new file. Especially, I would like to set the calculation mode to automatic, but changing this in the Excel preferences windows (Excel Menu => Preferences)…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 questions
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
483 questions
asked 2023-01-19T04:35:35.93+00:00
Beru 0 Reputation points
commented 2023-02-01T02:16:54.32+00:00
Ceasar Chen_MSFT 4,391 Reputation points
2 answers

Word document - worksheet object not opening in word it is not opening a new file in excel

Beginning last week, my word document excel object stopped opening in the microsoft word program. Instead, it opens up the excel workbook. The problem with this, I have lost the ability to resize to the inputted rows in word. This is a shared…

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
746 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,457 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 questions
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.
907 questions
asked 2023-01-18T15:29:04.3266667+00:00
Matthews, Trish 0 Reputation points
commented 2023-02-01T02:15:31.03+00:00
Ceasar Chen_MSFT 4,391 Reputation points
1 answer

Prompt to enable Macro's isn't consistent Office 2019 - Excel

Hello, I was wondering if anyone would be able to provide some insight on why it seems the prompt to enable macro's on Excel behaves very inconsistently. Our CRM system gives files the 'Mark of the Web' so following the recent changes…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 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,688 questions
asked 2023-01-17T10:48:37.31+00:00
Connor Smith 0 Reputation points
commented 2023-02-01T02:12:10.7566667+00:00
Ceasar Chen_MSFT 4,391 Reputation points
0 answers

In a team channel why does an excel spreadsheet duplicate and add on my device name at the end of the file?

I was working on an excel spreadsheet and some how made a copy and my laptop name was added onto the end of the file name.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 questions
asked 2023-01-16T23:24:49.6333333+00:00
Baillie, Kirsty 0 Reputation points
commented 2023-02-01T02:10:07.68+00:00
Ceasar Chen_MSFT 4,391 Reputation points