1,476 questions with Excel tags

Sort by: Updated
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,476 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.
463 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
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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,476 questions
asked 2023-01-21T16:13:09.69+00:00
Naveen Ganpat 26 Reputation points
commented 2023-01-31T09:37:07.86+00:00
Emily Hua-MSFT 27,526 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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,476 questions
asked 2023-01-30T21:16:57.1066667+00:00
Wiltzius, Nate 0 Reputation points
answered 2023-01-31T06:41:43.9333333+00:00
Emily Hua-MSFT 27,526 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

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,476 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,643 questions
asked 2023-01-19T10:52:23.3133333+00:00
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?

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
666 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,476 questions
asked 2023-01-11T13:37:25.6433333+00:00
Şafak Yacan 0 Reputation points
commented 2023-01-30T09:57:20.1933333+00:00
Emi Zhang-MSFT 22,011 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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,476 questions
asked 2023-01-16T15:26:45.68+00:00
Alix Jenevizian 0 Reputation points
commented 2023-01-30T09:53:59.64+00:00
Emi Zhang-MSFT 22,011 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…

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
666 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,476 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,216 questions
asked 2023-01-18T16:23:17.8833333+00:00
Patrick Poore 0 Reputation points
commented 2023-01-30T09:52:35.66+00:00
Emi Zhang-MSFT 22,011 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/…

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,832 questions
Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
666 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,476 questions
asked 2023-01-19T15:46:03.31+00:00
Ally (GHE) 0 Reputation points
commented 2023-01-30T09:51:56.4666667+00:00
Emi Zhang-MSFT 22,011 Reputation points Microsoft Vendor
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
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
666 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,317 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.
221 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,476 questions
asked 2023-01-23T09:48:36.7633333+00:00
Vishvajit Das 0 Reputation points
commented 2023-01-30T09:50:33.2033333+00:00
Emi Zhang-MSFT 22,011 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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,476 questions
asked 2023-01-23T13:27:33.6966667+00:00
andrea de lorenzo smit 0 Reputation points
commented 2023-01-30T09:50:14.1033333+00:00
Emi Zhang-MSFT 22,011 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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,476 questions
asked 2023-01-26T00:33:52.3066667+00:00
Kara Campbell 0 Reputation points
commented 2023-01-30T09:42:59.3466667+00:00
Emi Zhang-MSFT 22,011 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,476 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,508 questions
asked 2023-01-27T22:09:01.7033333+00:00
Johnnie Math 0 Reputation points
commented 2023-01-30T07:54:13.5433333+00:00
Emily Hua-MSFT 27,526 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.…

Visio
Visio
A family of Microsoft products used to create diagrams and vector graphics.
77 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,476 questions
asked 2023-01-27T14:30:35.6533333+00:00
Martin Novotný 0 Reputation points
commented 2023-01-30T07:03:31.18+00:00
Emi Zhang-MSFT 22,011 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

PowerBI怎么用折线图反映今年和去年的同期数据

如何对比2022年1月和2023年一月的数据? X轴放什么? 两年的数据是分别建了日期表计算的,,求大神指导,,小白自学实在是搞不明白了 想要实现的是像图二PPT版本这样的两根折线图

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,476 questions
asked 2023-01-29T07:31:39.4166667+00:00
Jiayi He 41 Reputation points
answered 2023-01-29T14:02:05.2366667+00:00
Jiayi He 41 Reputation points
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

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,476 questions
asked 2023-01-26T21:23:16.6033333+00:00
Sue Williams 0 Reputation points
answered 2023-01-28T05:11:52.21+00:00
Dillon Silzer 54,646 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,476 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,276 questions
asked 2023-01-27T07:47:50.0733333+00:00
Ashok Kumar 161 Reputation points
edited the question 2023-01-27T07:56:11.2433333+00:00
Ashok Kumar 161 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,317 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,476 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,508 questions
asked 2023-01-26T14:05:26.6866667+00:00
Bill Spang 0 Reputation points
edited the question 2023-01-27T02:52:31.6066667+00:00
Emily Hua-MSFT 27,526 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

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,476 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,756 questions
asked 2023-01-20T08:32:04.92+00:00
Alan simpson 0 Reputation points
edited the question 2023-01-26T18:19:08.79+00:00
Oury Ba-MSFT 16,471 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

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,476 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,643 questions
asked 2023-01-26T16:37:14.55+00:00
KristieS 0 Reputation points
answered 2023-01-26T17:32:35.83+00:00
Dillon Silzer 54,646 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,476 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,508 questions
asked 2023-01-25T12:42:35.5566667+00:00
Senior, Russell (R.A.) 0 Reputation points
edited a comment 2023-01-26T12:16:45.4066667+00:00
Viorel 112.5K Reputation points