659 questions with Microsoft 365 and Office | Excel | Other | Other tags

Sort by: Updated
1 answer

auto populate data to another sheet in a workbook based on a populated field

I have an excel workbook that contains numerous tabs. Each tab tracks data for a unit and i need to be able to copy an entire row from any of the tabs to a separate tab based on whether or not a date is populated in one of the columns. all of the…

Microsoft 365 and Office | Excel | Other | Other
asked 2026-05-27T20:06:21.2333333+00:00
Miller, Shelly 0 Reputation points
commented 2026-05-28T23:03:40.2166667+00:00
Ashish Mathur 101.9K Reputation points Volunteer Moderator
1 answer One of the answers was accepted by the question author.

why do my formulas look like this?

the format of all of my simple sum and avg formulas has changed this morning... they look like this: =(SUM(R[-1]C2:R[-1]C)*R27C2)/(((COUNT(R[-5]C2:R[-5]C)-3)R27C2)+18000) and I want them back to how they were yesterday!

Microsoft 365 and Office | Excel | Other | Other
asked 2026-05-27T13:16:07.6366667+00:00
Thomas Maynard 20 Reputation points
accepted 2026-05-27T13:17:36.55+00:00
Thomas Maynard 20 Reputation points
1 answer

Microsoft keeps blocking MY access to MY Excel spreadsheets even after I have resolved the issue (the last time they did this)

Last night Microsoft graciously and gratuitously installed an update (without letting me know what it contained or helping me decide if I wanted to do this). As part of this unwanted update Microsoft decided that the code I had written for Excel was…

Microsoft 365 and Office | Excel | Other | Other
asked 2026-05-13T14:29:52.4566667+00:00
Unswayed By Assertions 5 Reputation points
commented 2026-05-15T00:32:00.9066667+00:00
Xavier-D 8,585 Reputation points Microsoft External Staff Moderator
1 answer

Why can't I access Coursera files in excel

I am taking Coursera classes that require me to open samples spreadsheets. When I sign into my paid annual Microsoft account it cannot access their files. What am I doing wrong?

Microsoft 365 and Office | Excel | Other | Other
asked 2026-05-12T23:59:55.2066667+00:00
Wendy Saunders 0 Reputation points
commented 2026-05-13T04:55:03.5733333+00:00
Bulldog 2,195 Reputation points
2 answers

Excel related problem

How to repair my excel my excel is not working how to resolve it

Microsoft 365 and Office | Excel | Other | Other
asked 2026-05-12T04:44:25.43+00:00
neha 0 Reputation points
answered 2026-05-12T05:18:47.4766667+00:00
DaveM121 882.3K Reputation points Independent Advisor
1 answer

I need some help creating the formula to extract data from a CSV data file

The CSV file produces the sample 2 lines of data I need a formula that will populate the following columns: Number Temp Number Type 2 R 1 M 1 Veg

Microsoft 365 and Office | Excel | Other | Other
asked 2026-05-10T05:00:18.8833333+00:00
JoePerp 0 Reputation points
answered 2026-05-10T05:00:30.1633333+00:00

AI answer

1 answer

Stock prices not refreshing Microsoft Excel 365 - "server is temporarily having problems" error

Been like this all day. This is getting old since this isn't the first time this has happened. When will it be fixed?

Microsoft 365 and Office | Excel | Other | Other
asked 2026-04-28T19:04:52.2233333+00:00
C. Scott 0 Reputation points
answered 2026-04-28T19:05:11.78+00:00

AI answer

1 answer One of the answers was accepted by the question author.

I AM UNABLE TO SELECT DATA TYPE AS STOCK AND UNABLE TO REFRESH STOCK TICKER PRICES

I HAVE BEEN USING OFFICE 365 WEB VERSION FOR FEW WEEKS FOR MANAGING MY STOCKS IN INDIA , TODAY I AM UNABLE TO REFRESH DATA OF STOCKS . I TRIED CREATING A NEW SHEET BUT I M NOT GETTING ANY OPTION FOR DATA TYPE AS STOCK

Microsoft 365 and Office | Excel | Other | Other
asked 2026-04-28T08:24:53.7566667+00:00
AMITABH KUMAR 20 Reputation points
accepted 2026-04-28T09:11:04.9466667+00:00
AMITABH KUMAR 20 Reputation points
2 answers One of the answers was accepted by the question author.

the share button in Excel is not working. i keep getting the msg to save my changes first, which i have done many times.

My Share button in Excel is not working. I keep getting the msg. to save my changes first, which I have done many times.

Microsoft 365 and Office | Excel | Other | Other
asked 2026-04-23T16:33:56.7966667+00:00
Robert Fippinger 20 Reputation points
answered 2026-04-23T16:42:09.66+00:00
Robert Fippinger 20 Reputation points
2 answers

lost excel data may be forget to save

I lost some data in excel I found that the data which I updated may be forgot to save I don't know can I get latest data back

Microsoft 365 and Office | Excel | Other | Other
asked 2026-04-22T15:56:06.0333333+00:00
Office 0 Reputation points
answered 2026-04-22T17:02:36.0333333+00:00
IGYQ 19,275 Reputation points Independent Advisor
1 answer

Documentation for VML Drawing Files

Hi there, I have noticed that, when notes or threaded comments are added in an Excel file, their position information is written in a .vml file rather than the standard drawing.xml file. I have looked for the documentation but could not find it…

Microsoft 365 and Office | Excel | Other | Other
asked 2026-04-15T07:09:19.8066667+00:00
Ashwin Kannan 0 Reputation points
commented 2026-04-16T23:39:10.43+00:00
Xavier-D 8,585 Reputation points Microsoft External Staff Moderator
2 answers

Why VLOOKUP Fails Even When Data Exists

When using a VLOOKUP formula, an error is returned even though the lookup value exists in the source data range. The value appears visually identical, but the formula does not return a match. This occurs consistently across multiple rows, suggesting a…

Microsoft 365 and Office | Excel | Other | Other
asked 2026-04-06T18:29:47.58+00:00
Yadav, Aashish 0 Reputation points
commented 2026-04-16T00:11:53.3066667+00:00
Xavier-D 8,585 Reputation points Microsoft External Staff Moderator
2 answers

Issue with MS365W

Dear QA Team, I am reporting an issue in Microsoft Excel (Microsoft 365) where the application becomes slow and sometimes produces incorrect calculation results when working with large workbooks. The issue occurs when opening files with large datasets,…

Microsoft 365 and Office | Excel | Other | Other
asked 2026-04-11T19:35:22.2566667+00:00
SME-EDU 0 Reputation points
commented 2026-04-14T06:31:04.43+00:00
Kai-H 18,195 Reputation points Microsoft External Staff Moderator
2 answers

existing spreadsheets have started putting a line through calculated values

I have been having problems with exisiting spreadsheets putting a line through calculated values and cells that have these values have stopped calculating.

Microsoft 365 and Office | Excel | Other | Other
asked 2026-04-06T18:15:19.13+00:00
Rusty 0 Reputation points
commented 2026-04-07T22:56:48.75+00:00
Kal-D 7,365 Reputation points Microsoft External Staff Moderator
2 answers

Issues with Excel Crashing

I work with Excel throughout the day everyday. Since Monday the program keeps crashing. Usually when I add a date. The only way out of it is to use the task manager and lose any progress. Please call me at 3465324901 Brandy Anderson

Microsoft 365 and Office | Excel | Other | Other
asked 2026-04-07T13:13:39.9+00:00
Brandy Anderson 0 Reputation points
answered 2026-04-07T13:51:31.5966667+00:00
Lester Bernard Reyes 80,375 Reputation points Independent Advisor
2 answers

macros dont open r calculate on some machines but do on others

i need help willing to pay to solve this issue of macros not working on a machine but does on another

Microsoft 365 and Office | Excel | Other | Other
asked 2026-04-05T14:14:17.5733333+00:00
Jay Winestein 0 Reputation points
commented 2026-04-06T22:50:04.1033333+00:00
Kal-D 7,365 Reputation points Microsoft External Staff Moderator
1 answer

Microsoft 365, Excel: How to check a column's reference #'s and add the matching values in another column

Excel Spreadsheet, using rows 2-175. Column B=$ value, Column C = Reference # (approximately 10 of them, using 1010 as a reference in this case). Am trying to add a formula at the end of spreadsheet to check all of C cells and if they equal 1010, then…

Microsoft 365 and Office | Excel | Other | Other
asked 2026-04-04T16:14:12.8+00:00
Kevin JD 0 Reputation points
commented 2026-04-04T16:47:32.5266667+00:00
Kevin JD 0 Reputation points
1 answer

Excel cell hyperlink cannot be clicked

我复制黏贴到excel表格上的一些超链接,,有些可以,有些不可以,怎么办,我的记录行数比较多,无法实现一个个去重新复制

Microsoft 365 and Office | Excel | Other | Other
asked 2026-04-04T03:36:06.4466667+00:00
shen he 0 Reputation points
answered 2026-04-04T15:00:25.9333333+00:00
EmilyS726 234.5K Reputation points Independent Advisor
2 answers

How to insert many rows with many cells in between existing rows with many cells

I want to put blank row with many cells in between rows with cells with existing data, there are numerous of these

Microsoft 365 and Office | Excel | Other | Other
asked 2026-03-16T18:55:43.9166667+00:00
robert jacobs 0 Reputation points
commented 2026-04-02T22:23:25.0366667+00:00
Kal-D 7,365 Reputation points Microsoft External Staff Moderator
3 answers

Excel online version deleted my sheet and I can't recover it in version history or undo

Excel online version deleted my sheet and I can't recover it in version history or undo?

Microsoft 365 and Office | Excel | Other | Other
asked 2026-04-01T01:54:30.75+00:00
Lodes, Georgia 0 Reputation points
answered 2026-04-01T02:31:41.53+00:00
Arlene D 36,060 Reputation points Independent Advisor