Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 questions
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
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,600 questions
asked 2023-01-30T17:01:16.05+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 64%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
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,668 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,686 questions
asked 2023-01-11T21:41:38.91+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 0%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMO%3C/text%3E%3C/svg%3E)
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,668 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,694 questions
asked 2023-01-31T16:49:10.96+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 55.00000000000001%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWW%3C/text%3E%3C/svg%3E)
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?
asked 2023-01-19T19:53:29.9733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 50%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
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,668 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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 15%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
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.
743 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,447 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 2%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
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…
asked 2023-01-17T10:48:37.31+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 6%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
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.
asked 2023-01-16T23:24:49.6333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 15%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
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,447 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 questions
asked 2023-01-16T16:56:38.5733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 62%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
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").
asked 2023-01-13T00:18:26.34+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 61%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJE%3C/text%3E%3C/svg%3E)
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,668 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,694 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,686 questions
asked 2023-01-29T18:37:22.82+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 97%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGR%3C/text%3E%3C/svg%3E)
Gib Roberts
0
Reputation points
edited the question 2023-02-01T01:41:44.77+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 89%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Jiachen Li-MSFT
28,781
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…
asked 2023-01-19T20:08:17.0033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 21%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Sylvester McLeod
81
Reputation points
answered 2023-01-31T13:36:44.6333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 34%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP9%3C/text%3E%3C/svg%3E)
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.…
asked 2023-01-30T10:17:05.9166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 28.000000000000004%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
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
2 answers
Find correct SUM value of inventory before a date
PLEASE BE INFORMED THAT I WANT TO HAVE THE SOLUTION IN EXCEL NOT POWER BI Hi all, I have a dataset and want to perform some calculations with a measure. To this end, I have changed the AdventureWorks dataset (publicly available) to make my problem more…
asked 2023-01-21T16:13:09.69+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 37%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENG%3C/text%3E%3C/svg%3E)
Naveen Ganpat
26
Reputation points
commented 2023-01-31T09:37:07.86+00:00
Emily Hua-MSFT
27,591
Reputation points
1 answer
Calling Snowflake Stored Procedure from inside Microsoft Excel gets data for preview but doesn't load rows into spreadsheet
I have a Snowflake Stored Procedure that performs a simple Selection and Update on <100 rows. It then returns the selected rows as a new table. I have an ODBC connection to Snowflake that I am then using to call this Stored Procedure from inside a new…
asked 2023-01-30T21:16:57.1066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 38%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWN%3C/text%3E%3C/svg%3E)
Wiltzius, Nate
0
Reputation points
answered 2023-01-31T06:41:43.9333333+00:00
Emily Hua-MSFT
27,591
Reputation points
6 answers
number format in excel sheet
Hi Expert how to change datatype in pivot table in excel sheets . from text to numbers currently value is in text as it is in column section i,e. id value 1 23
asked 2023-01-19T10:52:23.3133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Shambhu Rai
1,406
Reputation points
answered 2023-01-30T15:44:12.54+00:00
Shambhu Rai
1,406
Reputation points
1 answer
Compatible mode
My university has an agreement with Microsoft about word, excell and powerpoint. I have used to have the program with this way. But today it has an alert and says that your account doesn't allow to edit on a Mac. How to get fixed the problem?
asked 2023-01-11T13:37:25.6433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 62%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAY%3C/text%3E%3C/svg%3E)
Şafak Yacan
0
Reputation points
commented 2023-01-30T09:57:20.1933333+00:00
Emi Zhang-MSFT
23,586
Reputation points Microsoft Vendor
1 answer
How to use formulas in excel when exporting data using forms?
The formula I am using is =IF(COUNTBLANK(B12)=0, VLOOKUP(B12,lookupTab,2,0), "") It all works perfectly UNTIL I submit a new answer on the forms then the cells shift when new information is added and therefore it doesn't correctly give the…
asked 2023-01-16T15:26:45.68+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 8%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Alix Jenevizian
0
Reputation points
commented 2023-01-30T09:53:59.64+00:00
Emi Zhang-MSFT
23,586
Reputation points Microsoft Vendor
1 answer
Unable to open embedded word files in excel - 'cannot start the source application for this file' error message
Updated to windows 11 start of the year (unable to roll back) - all excel documents that have 1 or more word documents in them cannot be opened- 'cannot start the source application for this file'. =EMBED("Document","" is in the…
asked 2023-01-18T16:23:17.8833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 17%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Patrick Poore
0
Reputation points
commented 2023-01-30T09:52:35.66+00:00
Emi Zhang-MSFT
23,586
Reputation points Microsoft Vendor
3 answers
How to fix the Word/Excel error message....
This issue is only on one pc but they can open all pdf's documents with the cloud folders - they can see all contents within the folders. All updates have been completed for 365 apps. This machine can open the document if sent to the pc via Teams/…
asked 2023-01-19T15:46:03.31+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 8%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Ally (GHE)
0
Reputation points
commented 2023-01-30T09:51:56.4666667+00:00
Emi Zhang-MSFT
23,586
Reputation points Microsoft Vendor