Word
A family of Microsoft word processing software products for creating web, email, and print documents.
743 questions
1 answer
my office shows error it came preinstalled with my laptop but all of a sudden it showing need to signup again do i need to buy new office subscription?
recently i am seeing an error whenever i am opening excel or any office apps, microsoft office came preinstalled on my system by default but now its showing some errors what should i do now
Word
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
PowerPoint
PowerPoint
A family of Microsoft presentation graphics products that offer tools for creating presentations and adding graphic effects like multimedia objects and special effects with text.
250 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 questions
asked 2023-01-23T09:48:36.7633333+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, 14.000000000000002%, 16%)' 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)
Vishvajit Das
0
Reputation points
commented 2023-01-30T09:50:33.2033333+00:00
Emi Zhang-MSFT
23,586
Reputation points Microsoft Vendor
1 answer
new computer, same configuration but excel dosen't work with RTD data from trading software
Hello, I use an excel spreadsheet linked to the CME E-quotes platform via RTD to receive live feeds of prices; i bought new computer but now i can't figure how to make it work. Old computer has Windows 10 and Office 2013; new computer has the same; the…
asked 2023-01-23T13:27:33.6966667+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(208, 22%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
andrea de lorenzo smit
0
Reputation points
commented 2023-01-30T09:50:14.1033333+00:00
Emi Zhang-MSFT
23,586
Reputation points Microsoft Vendor
1 answer
Automatically transfer information from one spreadsheet to another based on id number
I have 2 different sheets with cattle data. Weights, birthdate, names, etc.. One sheet contains information and the other sheet is has some information, but needs to have weights, birthdate, etc transferred from the completed spreadsheet to the…
asked 2023-01-26T00:33:52.3066667+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(214.4, 23%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
Kara Campbell
0
Reputation points
commented 2023-01-30T09:42:59.3466667+00:00
Emi Zhang-MSFT
23,586
Reputation points Microsoft Vendor
0 answers
Excel to API without going through Power Query
Hello! We recently connected Power BI to our API and Power BI read the data right into a table (just about automatically). We want to do the same thing with an Excel connection to our API. However, every tutorial and video I've seen shows that you must…
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-27T22:09:01.7033333+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(108.80000000000001, 77%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Johnnie Math
0
Reputation points
commented 2023-01-30T07:54:13.5433333+00:00
Emily Hua-MSFT
27,591
Reputation points
1 answer
Change active page of Vision object in Excel
I have an Excel document in which I inserted Visio object. It has a few pages, each page has a specific model and according to some checkboxes in excel I want to choose a specific page, so when I print the excel, it will have specific model from visio.…
asked 2023-01-27T14:30:35.6533333+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, 37%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Martin Novotný
0
Reputation points
commented 2023-01-30T07:03:31.18+00:00
Emi Zhang-MSFT
23,586
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
PowerBI怎么用折线图反映今年和去年的同期数据
如何对比2022年1月和2023年一月的数据？ X轴放什么？ 两年的数据是分别建了日期表计算的，，求大神指导，，小白自学实在是搞不明白了 想要实现的是像图二PPT版本这样的两根折线图
![](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, 80%, 16%)' 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)
1 answer
If I sign in to Microsoft on another computer can I see my excel files.
I signed into another computer with my microsoft account and could see my excel file history. Were the files also there
asked 2023-01-26T21:23:16.6033333+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(281.6, 69%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESW%3C/text%3E%3C/svg%3E)
Sue Williams
0
Reputation points
answered 2023-01-28T05:11:52.21+00:00
Dillon Silzer
55,881
Reputation points
0 answers
How to download rest api response content into excel using windows forms application c#
I'm trying to download REST API response content as (original format) excel (.xlsx) And I have used this method to return the response content public static string DownloadFileName() { try { var client = new…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 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,600 questions
asked 2023-01-27T07:47:50.0733333+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(102.4, 40%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Ashok Kumar
201
Reputation points
edited the question 2023-01-27T07:56:11.2433333+00:00
Ashok Kumar
201
Reputation points
0 answers
M365 VBA Compatibility Issues with TN3270 Emulator
I am experiencing M365 VBA Compatibility Issues with TN3270 Emulator. I cannot find any documentation, so your experience on the subject is much appreciated. I have an enterprise client running legacy TN3270 Emulator. I developed an Employee Survey in…
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
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-26T14:05:26.6866667+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(201.6, 72%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bill Spang
0
Reputation points
edited the question 2023-01-27T02:52:31.6066667+00:00
Emily Hua-MSFT
27,591
Reputation points
1 answer
Can you create a sql query to look up the data entered into a cell?
looking to create a formula that will look up every entry in a list that has the specific value which would be entered into cell A1
asked 2023-01-20T08:32:04.92+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(240, 82%, 33%)' 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)
Alan simpson
0
Reputation points
edited the question 2023-01-26T18:19:08.79+00:00
Oury Ba-MSFT
17,786
Reputation points Microsoft Employee
1 answer
Best courses to become certified in Excel and PowerPoint
I would like to become certified in excel, What is the best option in doin this? Thank you
asked 2023-01-26T16:37:14.55+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(150.4, 35%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
KristieS
0
Reputation points
answered 2023-01-26T17:32:35.83+00:00
Dillon Silzer
55,881
Reputation points
0 answers
Using Shell Namespace method "GetDetailsOf" causes excel to crash
I'm using a vba script to summarize a list of data files in certain folders so I can manage those files (mark important, not important, whether I've used them in presentations, etc.). The files are created by a program called Vector CANape and are MDF…
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-25T12:42:35.5566667+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(64, 7.000000000000001%, 16%)' 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)
Senior, Russell (R.A.)
0
Reputation points
edited a comment 2023-01-26T12:16:45.4066667+00:00
Viorel
114.4K
Reputation points
1 answer
Conditional Formatting - Before and after expiry date
I'm trying to set up conditional formatting for a spreadsheet. I have a date when I received a consent letter, I'd like this to be coloured green if consent is still valid and red if consent has expired (18 months after receipt of letter). Any…
asked 2023-01-25T14:50:25.7266667+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, 52%, 17%)' 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)
Cassidy, Niamh
0
Reputation points
commented 2023-01-26T02:12:58.5533333+00:00
Emi Zhang-MSFT
23,586
Reputation points Microsoft Vendor
0 answers
Month over Month variance Power Pivot
Hi I am using Power Pivot for a revenue table with customers down the left and 24 months along the top. I am looking for guidance on how to add a MoM measurement just for the current month over the previous month (similar to a calculated field in a…
asked 2023-01-24T23:20:22.9033333+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, 50%, 31%)' 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)
BryanCF
0
Reputation points
commented 2023-01-25T06:44:54.6966667+00:00
Emi Zhang-MSFT
23,586
Reputation points Microsoft Vendor
1 answer
Dataverse sql server - nvarchar column not showing in proper format in excel vba recordset field..
Hi, We are trying to fetch record from MS Dataverse using ODBC driver 17/18 for Sql Server into Excel using Macro(VBA) code. Issue: There are some columns with type nvarchar which are not showing in proper format as it shows for other columns. I…
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-19T15:18:01.71+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(224.00000000000003, 72%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Saurabh Pathak
31
Reputation points
edited the question 2023-01-23T07:44:28.8433333+00:00
Emily Hua-MSFT
27,591
Reputation points
0 answers
OLEO-object (checkbox) in Excel VBA causes problems (error 1004) with MS defender in company network
Hi there, I created an Excel VBA-project that includes checkboxes. On my PC (Office 365) everything runs fine. In the company network it was fine until the IT department changed something regarding the defender safety precautions: Code sample:…
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-21T15:38:20.6966667+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(25.6, 80%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Chris
0
Reputation points
edited the question 2023-01-23T03:04:07.4633333+00:00
Emily Hua-MSFT
27,591
Reputation points
0 answers
How to fix an Excel UDF that calculates correctly on one line but reports the wrong info when flash filling
Hi Finally figured out how to write this UDF that calculates position in a range. problem is when the sheet is refreshed or a flash fill is done, then the UDF incorrectly makes all the values the same. since this is happening in a sheet, is there a way…
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-20T11:49:31.01+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(137.6, 26%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
dan mcgovern
0
Reputation points
edited the question 2023-01-23T01:06:08.49+00:00
Emily Hua-MSFT
27,591
Reputation points
0 answers
Excel Office Add-In can't check Certificate Revocation List via LDap
I'm working on an Excel Add-In and when I try to hit an internal https API, I get a prompt in Excel stating "Revocation Information for the security certificate for this site is not available, Do you want to proceed?" I've confirmed that the…
asked 2023-01-18T18:38:19.1966667+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, 60%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBV%3C/text%3E%3C/svg%3E)
Bradley Vanderleeuw
0
Reputation points
edited a comment 2023-01-19T19:01:54.89+00:00
Bradley Vanderleeuw
0
Reputation points
0 answers
VBA becomes run-time error 424 after Office version upgrade
After Office upgrade (Version 2212 (Build 15928.20198)) If you import a standard module with VBA and execute a function in that module with call A run-time error 424 has occurred. Importing with ThisWorkbook.VBProject.VBComponents.Import file path. …
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-18T08:13:08.4333333+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, 83%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
ringo55
10
Reputation points
edited the question 2023-01-19T01:11:03.4366667+00:00
Emily Hua-MSFT
27,591
Reputation points
1 answer
One of the answers was accepted by the question author.
excel slow on local c drive
I have an excel program using vba to scrap a web page. When the program is launched from a network drive the program works as expected. But on the local c drive the same code takes about 10 times longer. This is happening on both my machines one with…
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-16T02:08:32.2+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, 89%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Graeme Mahoney
25
Reputation points
accepted 2023-01-18T01:24:28.5466667+00:00
Graeme Mahoney
25
Reputation points