.NET
Microsoft Technologies based on the .NET software framework.
4,104 questions
7 answers
One of the answers was accepted by the question author.
How to create Excel file with Visual Studio 2022 and C#
I'm working with Visual Studio 2022, Project WPF C# with .Net 6.0 and Entity Framework Core. DataBase MS SQL Express.I have also a valid and active licence Microsoft Office 365. I try to Create an Excel File but I have different error msg (see…
.NET
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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.
11,324 questions
asked 6 Aug 2023, 3:37 pm
![](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(44.800000000000004, 28.999999999999996%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Dmtr_Grms
331
Reputation points
commented 6 Mar 2025, 8:43 am
![](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(227.2, 9%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
subbarayan C
0
Reputation points
0 answers
Excel Plus 2024 no me ejecuta las funciones
Buenos días, comparto el problema que tengo en Excel Plus 2024, al que me refiero en una anterior pregunta. Gracias, por ayudarme a solucionarlo. La función que aplico, en esta oportunidad, es SUMAR.SI.CONJUNTO, pero como esta depende de una base de…
asked 1 Mar 2025, 3:51 pm
![](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, 97%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EME%3C/text%3E%3C/svg%3E)
Martha Elena Pérez Murcia
0
Reputation points
commented 6 Mar 2025, 8:24 am
![](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, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jiajing Hua-MFST
15,695
Reputation points Microsoft External Staff
0 answers
How to fix changing printing area in Microsoft Excel?
Hello everybody, i currently face the issue that my setting of the printing area changes after some time without changes on the document or the printer settings. I created a excel document as template where i did set up a range for a Din A4 page so the…
asked 6 Mar 2025, 7:49 am
![](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(281.6, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Guido Seibel
0
Reputation points
asked 6 Mar 2025, 7:49 am
Guido Seibel
0
Reputation points
2 answers
MSFT wants me to buy 365 that I don't need
I need Excel to fill in numbers in my bank accounts for filing tax return and cannot do it since MSFT blocked my Excel that I bought as part of the Office. I'm 76 years old and I don't need all this fancy stuff in 365. How can I get my Office Excel and…
asked 5 Mar 2025, 10:25 pm
![](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(128, 15%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAO%3C/text%3E%3C/svg%3E)
Alex Orlov
0
Reputation points
answered 6 Mar 2025, 2:55 am
Jiajing Hua-MFST
15,695
Reputation points Microsoft External Staff
1 answer
One of the answers was accepted by the question author.
Stacked Bars with Groupings
Hello, I am wanting to create a stacked bar chart that shows two sets of data. Basically, I want one bar to show the offer and start days for Exempt per month, and one to show the nonexempt offer and start days per month. Is there a way to do this in one…
![](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(252.8, 48%, 34%)' 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)
0 answers
hvordan kan man skjule arkfane i excel uden forbindelserne berøres.
Jeg vil gerne lære lidt mere om hvordan man kan skjule arkfane i en excel fil ?
asked 4 Mar 2025, 6:53 pm
![](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, 16%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
Julius Jakobsen
0
Reputation points
asked 4 Mar 2025, 6:53 pm
Julius Jakobsen
0
Reputation points
1 answer
Groupon Office 2024 download not working
FRUSTRATED!! We recently purchased the Office 2024 through Groupon in January of 2025 (less than 30 days ago). What a Horrible experience. Still to this day, we cannot access Word, Excel or any Office 2024 programs. We have reached out for help through…
asked 4 Mar 2025, 3:25 am
![](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(275.2, 11%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Robert Benavides
0
Reputation points
answered 4 Mar 2025, 8:20 am
Jiajing Hua-MFST
15,695
Reputation points Microsoft External Staff
7 answers
How to fix error AADSTS500200: User account is a personal Microsoft account. Personal Microsoft accounts are not supported for this application
Sorry, but we’re having trouble signing you in. AADSTS500200: User account 'su***********@gmail.com' is a personal Microsoft account. Personal Microsoft accounts are not supported for this application unless explicitly invited to an organization. Try…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,917 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
23,521 questions
asked 3 Jan 2024, 10:26 am
![](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(3.2, 54%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sumit
70
Reputation points
answered 4 Mar 2025, 1:24 am
![](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(44.800000000000004, 20%, 14%)' 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)
Sheela Rance
5
Reputation points
1 answer
One of the answers was accepted by the question author.
How to Fix Previously Working Macros in Excel that are Now Blocked/Not Loading
(Note: I was directed here from MS Support) I have several excel files that I use in daily work that have macros in them, executed via buttons. While working with one of these files, the macros stopped working. These files are important enough that I…
asked 27 Feb 2025, 7:08 pm
![](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(67.2, 97%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SRENV
20
Reputation points
commented 3 Mar 2025, 9:31 am
Jiajing Hua-MFST
15,695
Reputation points Microsoft External Staff
1 answer
Excel 'Get Data From Web' loses Authorization header
Hi, I work for a company that allows users to generate a HTML feed of data from various tables we hold within our software. In previous versions of Excel, users were able to generate a base64 encoded authorization string within our software, and then…
asked 19 Dec 2024, 7:52 am
![](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(128, 7.000000000000001%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Craig Dickinson
0
Reputation points
commented 3 Mar 2025, 9:20 am
Craig Dickinson
0
Reputation points
0 answers
Incorrect UK counties in Bing Maps for Power BI and Excel
The UK counties in Bing Maps for Excel and Power BI are not accurate, and there are multiple issues. This has been reported as far back as 2012. If you create an Excel table with three columns: Country (which must be UK), County, and Units, and create a…
asked 2 Mar 2025, 8:03 am
![](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, 26%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jim Blair
0
Reputation points
edited a comment 3 Mar 2025, 9:05 am
Jiajing Hua-MFST
15,695
Reputation points Microsoft External Staff
1 answer
The Excel object inserted into PowerPoint cannot be opened
Right click in PowerPoint and select Excel object -->Worksheet object -->Open, but Excel application is not opened and PowerPoint does not respond. Any suggestion is appreciated.
asked 28 Feb 2025, 10:31 am
![](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(86.4, 39%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Aarav Singh
0
Reputation points
answered 3 Mar 2025, 5:31 am
Jiajing Hua-MFST
15,695
Reputation points Microsoft External Staff
1 answer
MSCOMCTL.OCX file is not working for list view
In Excel 2016, I couldn't find the "MSCOMCTL.OCX" file, so I downloaded it online and placed it in the SysWOW64 folder. After that, I registered the file and selected it from the library references. However, despite these steps, the ListView…
asked 28 Feb 2025, 6:41 pm
![](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, 77%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Saxena, Vishal
0
Reputation points
answered 3 Mar 2025, 3:05 am
Jiajing Hua-MFST
15,695
Reputation points Microsoft External Staff
1 answer
One of the answers was accepted by the question author.
Unwanted checkboxes appear in a shared Excel file
I created an Excel file for members of my club to share and gave them a link and allowed them to edit it. All they need to do is to enter a 'Y' or a 'N' in the cells along a row which is headed by their name. I check and archive the file every day. The…
![](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, 42%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
How can I automatically format a range as a table and apply conditional formatting in Excel using VBA?
I write content for a site where I often have to create tables. I create tables from Google Docs, but the tables are not good. However, I have problems creating tables in Google Docs. But I use Microsoft Excel to create tables well. But I can't easily…
![](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(300.8, 28.999999999999996%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETI%3C/text%3E%3C/svg%3E)
2 answers
How to fix this error that happens when I try to convert xls to pdf
The warning in the picture pops up when I try to save an excel file (format: xls) into pdf using the save as function. When translated, it means "This file format is not supported by Microsoft Information Protection. You must convert the document…
asked 8 Oct 2024, 11:35 am
![](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(25.6, 28.000000000000004%, 12%)' 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)
Ji Su Seo
0
Reputation points
edited an answer 28 Feb 2025, 2:01 pm
![](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(0, 87%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
nicolay --
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Excel formula
Put different numbers from two rows on the third row. Any suggestion is appreciated, thanks.
![](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(291.2, 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' %3EJL%3C/text%3E%3C/svg%3E)
4 answers
Get help to amend my syntax
I have two separate syntax to sum up value. Could anyone help me to combine the syntaxs in one go?
asked 25 Feb 2025, 5:45 pm
![](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' %3EAC%3C/text%3E%3C/svg%3E)
Alan Chen
0
Reputation points
commented 28 Feb 2025, 8:36 am
Emi Zhang-MSFT
28,356
Reputation points Microsoft External Staff
1 answer
MSoffice 2019 - Microsoft Excel is not working.
We have purchased MS office 2019 Professional through one of our supplier. This was purchased for one the control system project of ours supplied to IOCL. for mapping the purchased MS Office to a email ID, one email ID was created…
asked 21 Feb 2025, 8:05 am
![](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, 76%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHA%3C/text%3E%3C/svg%3E)
Himanshu Augastya
0
Reputation points
commented 28 Feb 2025, 8:33 am
Emi Zhang-MSFT
28,356
Reputation points Microsoft External Staff
1 answer
Excel - Data validation rules
Hi All, How can I make a cell mandatory based on an answer in another cell? For example, I want cells in Column K to be mandatory IF the users replied "To be Assigned" in Cell C. Thanks in advance!!
asked 17 Feb 2025, 3:54 pm
![](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(179.20000000000002, 72%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFG%3C/text%3E%3C/svg%3E)
Felipe Giordano
20
Reputation points
commented 28 Feb 2025, 8:31 am
Emi Zhang-MSFT
28,356
Reputation points Microsoft External Staff