1,555 questions with Excel tags

Sort by: Updated
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,482 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,730 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,555 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,599 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,555 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,551 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,555 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.
12,951 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,423 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 41,806 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.
10,913 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,555 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
880 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,599 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,946 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.
701 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,555 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,612 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,599 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 22,716 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,555 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 22,716 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,555 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,551 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,555 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,423 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,555 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,028 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,662 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,555 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,599 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,551 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,555 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,555 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.
474 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.
701 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,368 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,555 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.
903 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,555 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,662 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,555 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
2 answers

undo change in two worksheets

When I have two worksheets open and I copy information from one to another, when I undo a change in one, I undo the other one as well. How to take it off?

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,368 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,555 questions
asked 2023-01-16T16:56:38.5733333+00:00
BiCa7 20 Reputation points
commented 2023-02-01T02:09:33.59+00:00
Ceasar Chen_MSFT 4,391 Reputation points
1 answer

How do I access the contents of a cell in another worksheet

As I update Income projections in one worksheet (e.g."income"), I want those updates to be reflected (updated) in a second worksheet (e.g."Budget").

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,555 questions
asked 2023-01-13T00:18:26.34+00:00
John Eisele 0 Reputation points
edited a comment 2023-02-01T02:03:06.4966667+00:00
Ceasar Chen_MSFT 4,391 Reputation points
0 answers

How to update cells in a row when a particular cell in the same row is changed

I have a 2 page excel file. Page 1: "List" page has 6 columns and infinite rows Column names: A: Date B: Symbol, Text C: Source, =TradeSource D SignalApp, =INDIRECT($C2,TRUE) E: Pattern, =INDIRECT($D2,TRUE) F: Cull Date "Source, App,…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,555 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,599 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,662 questions
asked 2023-01-29T18:37:22.82+00:00
Gib Roberts 0 Reputation points
edited the question 2023-02-01T01:41:44.77+00:00
Jiachen Li-MSFT 27,411 Reputation points Microsoft Vendor
3 answers One of the answers was accepted by the question author.

Excel Power Query equivalent for an excel formula

Hi there, I am super new to Power Query in Excel and hoping to get some help. I am not sure if what I am asking is possible or not but thought I'd reach out and ask. I have a column in an excel power query with hours represented in a decimal format. In…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,555 questions
asked 2023-01-19T20:08:17.0033333+00:00
Sylvester McLeod 81 Reputation points
answered 2023-01-31T13:36:44.6333333+00:00
Prasad-9947 1 Reputation point
2 answers

Microsoft office Excel 2021 with FSlogix 2.9.8228.50276

We implemented a VDI solution with Windows 10 Ent, Fslogix 2.9.8228.50276, with the Profile Container active and storing the VHDX to an SSD storage. However, we have noticed a strange behavior with the office tools, in particular with excel 2021.…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,555 questions
FSLogix
FSLogix
A set of solutions that enhance, enable, and simplify non-persistent Windows computing environments and may also be used to create more portable computing sessions when using physical devices.
467 questions
asked 2023-01-30T10:17:05.9166667+00:00
Município Câmara de Lobos 0 Reputation points
answered 2023-01-31T10:18:40.6633333+00:00
Município Câmara de Lobos 0 Reputation points