Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 questions
1 answer
How to create a report that shows number of trained individuals vs total population to be trained
I am trying to create a visualization report that shows the total number of individuals required to attend a training and those who have completed the training. I've tried to create the report using the staked column chart but it only displays the…
asked 2023-01-03T18:50:23.217+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(198.4, 79%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Julia Salgado
1
Reputation point
edited the question 2023-02-14T09:22:19.38+00:00
Emi Zhang-MSFT
23,906
Reputation points Microsoft Vendor
2 answers
How can I modify this pivot table to show the desired data?
I am creating a pivot table where the row is the reason code, the column the month/year, and the values Distinct Count of Production Number. There are moments where a production number is found in reason code 4 and 22 or in 5 and 26. Regardless, how can…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 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,715 questions
asked 2023-01-04T00:01:12.593+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(70.4, 15%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
Lopez, Ahiezer
236
Reputation points
edited the question 2023-02-14T09:21:50.03+00:00
Emi Zhang-MSFT
23,906
Reputation points Microsoft Vendor
0 answers
Cell border created with macro seems to be fixed to cell=ignores filter
Dear all, A tried to substitute conditional formatting function by writing a code. It seemed to be working, except one issue. After sorting the columns the cell border does not move with the original cell values. The CellBorder remains on the original…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 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,715 questions
asked 2023-02-13T08:01:51.8+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(268.8, 91%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVD%3C/text%3E%3C/svg%3E)
Veronika Dicerova
0
Reputation points
edited the question 2023-02-14T06:46:43.6933333+00:00
Emily Hua-MSFT
27,601
Reputation points
1 answer
Help saving to Dropbox
I subscribe to Microsoft 365 and when trying to save an Excel Workbook on my MAC the options are just iCloud but I only use DropBox for my files. Why isn't that an option? This used to work seamlessly but all of a sudden in Excel - dropbox isn't an…
Microsoft Office Online Server
Microsoft Office Online Server
Microsoft on-premises server product that runs Office Online. Previously known as Office Web Apps Server.
616 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 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
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,689 questions
asked 2023-01-03T10:22:17.587+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(220.8, 90%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELL%3C/text%3E%3C/svg%3E)
Lee Lessack
1
Reputation point
edited the question 2023-02-13T09:44:09.7566667+00:00
Emily Hua-MSFT
27,601
Reputation points
1 answer
Open and use MS Excel with macro straight forward from network shares
Hello, We have a DFS file server, so company clients access to network shares using this path \company.local\shares These endpoint can access to DFS without trouble (they open, save file etc...). I downloaded and applied ADMX for MS Office…
Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
5,092 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,624 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,689 questions
asked 2023-01-03T09:10:26.183+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, 27%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFC%3C/text%3E%3C/svg%3E)
Federico Coppola
1,181
Reputation points
edited the question 2023-02-13T09:42:19.55+00:00
Emily Hua-MSFT
27,601
Reputation points
1 answer
office 365 - outlook now opening excel attachments as read only
we have office 365, and suddenly today, I am seeing lots of people complaining that when they receive an excel spreadsheet via email, it is always opening in Read Only mode. I have tried in Excel going to Trust Center and unchecking everything under…
asked 2023-01-04T16:00:47.517+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(243.2, 24%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Captain Kirk
121
Reputation points
edited the question 2023-02-13T09:41:40.5966667+00:00
Emily Hua-MSFT
27,601
Reputation points
5 answers
Need a formula
Need a formula to find a cell with text in a worksheet and copy the numeric value to the right of that cell into another worksheet
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 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,715 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,067 questions
asked 2023-01-05T11:20:35.53+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(220.8, 14.000000000000002%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Maurizio5
6
Reputation points
edited the question 2023-02-13T09:40:23.6466667+00:00
Emily Hua-MSFT
27,601
Reputation points
1 answer
One of the answers was accepted by the question author.
Chinese displays as '?'
Dear All, When I export data from VFP9 to a text file with the following command copy to _trainer.xls delimited with tab My region setting of my Windows is as follows: If I open the file (_trainer.xls) in Notepad, the Chinese characters appear…
asked 2023-01-10T04:36:23.53+00:00
BenTam
1,621
Reputation points
edited the question 2023-02-13T09:38:30.47+00:00
Emily Hua-MSFT
27,601
Reputation points
1 answer
How to fix excel corrupted files for excel? I have save the file in seagate harddisk? I am currently using window 11.
How to fix excel corrupted files for excel? I have save the file in seagate harddisk? I am currently using window 11.
asked 2023-01-11T06:00:18.5833333+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(105.60000000000001, 82%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKL%3C/text%3E%3C/svg%3E)
Karen Lim
0
Reputation points
edited the question 2023-02-13T09:37:22.93+00:00
Emily Hua-MSFT
27,601
Reputation points
1 answer
Have Recon with only 2 columns but might have several rows on other to match, how can I find Matches?
Have a general Ledger account debit / credit but sometimes/most it several credits to match one debit, i have been doing by adding subtracting and takes a long long time. Plus they don't really have a unique name that would match the debit to credits,…
asked 2023-01-14T18:58:32.0333333+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(147.20000000000002, 70%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
J806
0
Reputation points
edited the question 2023-02-13T09:36:16.1733333+00:00
Emily Hua-MSFT
27,601
Reputation points
1 answer
One of the answers was accepted by the question author.
Threaded comment support by Office professional version of Excel
Is threaded comment supported by Office professional Plus 2021 version of Excel? When I tried to edit the comments by it that are edited by Office Home and Business 2021 or Microsoft 365 enterprise version of Excel, every single comment shows an error…
asked 2023-01-14T07:39:16.0766667+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(124.80000000000001, 27%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Atsushi Ando
20
Reputation points
edited the question 2023-02-13T09:35:57.7366667+00:00
Emily Hua-MSFT
27,601
Reputation points
2 answers
Creating Excel and Word Objects in old Visual Basic 6 broken, again
Since mid January 2023 one of Microsoft Updates broke this functionnality. I need to support for at least one year old Visual Basic Applications for a client that uses VBA objects like Excel and Word. We are using Office 2016 32 bits edition. This was…
Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
751 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 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,715 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.
908 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,689 questions
asked 2023-01-31T15:17:10.2766667+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(96, 83%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%3C/text%3E%3C/svg%3E)
Richard Tremblay
0
Reputation points
edited the question 2023-02-13T09:30:24.1833333+00:00
Emily Hua-MSFT
27,601
Reputation points
2 answers
2D Map Chart
I am using Office LTSC Pro Plus 2021 x64 Multilingual, installed a Week ago Issue: Data tab > Data Types > Geography is not available in MSEXCEL and I am unable to create city name wise 2D Map chart, currently its only Province Or State Or Country…
asked 2023-01-31T19:06:40.88+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(80, 0%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZH%3C/text%3E%3C/svg%3E)
Zeeshan Haider
0
Reputation points
edited the question 2023-02-13T09:28:14.69+00:00
Emily Hua-MSFT
27,601
Reputation points
4 answers
SqlBulkCopy , ASP.NET web forms, Stuck without error
Hello, I have three excel files, uploading data from asp.net webforms and inserting into database. I am reading data from excel files and then from datatable inserting to database using SqlBulkCopy, sometime it works perfectly and then next time it…
asked 2023-02-09T14:48:57.2866667+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(73.60000000000001, 63%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tahir Shafique
21
Reputation points
commented 2023-02-13T08:30:46.5366667+00:00
Tahir Shafique
21
Reputation points
1 answer
Can I automatically get email subject lines and date and time into excel?
Whenever I receive an email in a specific folder in outlook I would like a new row to be added in an excel file. Date and time in column a and subject field in column b. Is that possible? And how? Thanks.
asked 2023-01-15T02:42:27.8333333+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, 33%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECN%3C/text%3E%3C/svg%3E)
Claus Nilsson
0
Reputation points
edited the question 2023-02-13T06:43:59.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(121.6, 11%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
ChristyZhang-MSFT
22,336
Reputation points Microsoft Vendor
3 answers
No Tables or Views when Connecting to Excel file in SSIS
Seriously, why in God's name is it SO HARD to connect to Excel!?! Visual Studio 2019 Excel 365 64-bit I added a Data Flow Task to my Control Flow Added Excel Source to the Data Flow Opened the Excel Source and clicked "New" to create a new…
asked 2023-02-11T00:54:32.5466667+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(169.60000000000002, 27%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Sean Hull
15
Reputation points
answered 2023-02-13T06:07:22.6066667+00:00
ZoeHui-MSFT
35,551
Reputation points
1 answer
Excel - sort multiple rows as groups
I have the following data: I want sort it by Asset Ranking so rows 6,7, and 8 will be on the top. Is it possible? Thanks
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 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,715 questions
asked 2023-02-10T12:59:18.24+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, 13%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
mark goldin
691
Reputation points
edited the question 2023-02-13T05:46:11.0633333+00:00
Emi Zhang-MSFT
23,906
Reputation points Microsoft Vendor
0 answers
Office Script; Excel online; Pivot Table; DataHierarchy field title
I would like to change the title for a Pivot Table DataHierarchy field. I cannot find any documentation. Specifically, I'd like to change the field name from "Sum of aDate" to "aDate" I'm using Office Script/Java Script. I tried…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,470 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 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,715 questions
asked 2023-02-10T20:28:16.0866667+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(211.20000000000002, 95%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Jenny Charlton
0
Reputation points
edited the question 2023-02-13T01:57:17.7466667+00:00
Emily Hua-MSFT
27,601
Reputation points
0 answers
Type Mismatch - shape properties vs cells value
Hiya, VBA is giving me type mismatch error when calculating value from excel range/cells value vs shape properties. Is there a way to resolve this error please? Initially Range "A1" was a formula which I'd changed to a number (format cell as…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 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,715 questions
asked 2023-02-10T15:48:54.9333333+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(307.2, 97%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
LYoong
0
Reputation points
edited the question 2023-02-13T01:56:10.52+00:00
Emily Hua-MSFT
27,601
Reputation points
1 answer
Getting Runtime Errors When Trying to Refresh Excel in SSIS Script Task
I am trying to refresh queries in an Excel via using SSIS. I created a script task as follows: using System; using System.Data; using Microsoft.SqlServer.Dts.Runtime; using Microsoft.Office.Interop.Excel; using System.Threading; using…