20,611 questions with Microsoft 365 and Office | Excel | For business | Windows tags

Sort by: Updated
1 answer

How to create dynamic worksheets that show scheduled volunteers by date based on master schedule

Hello, I have been searching for a solution to this problem unsuccessfully for hours. I work with a non-profit organization that posts the schedule of our 100 volunteers across 60 dates. I would like to create additional worksheets that provide the…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-05T00:36:01.7333333+00:00
Marianne McNamara 0 Reputation points
edited the question 2026-06-05T02:28:36.2166667+00:00
Vivian-HT 16,595 Reputation points Microsoft External Staff Moderator
1 answer

Excel not pulling info or won't search for stock names when entered into column selected for trading stocks.

I am a new user of excel. I created a basic spreadsheet for trading stocks with no special coding or formulas. 1 column is for the stock names (as applied under "Data" and "Stocks" for that column), and when I enetered the stock name,…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-04T20:37:03.39+00:00
m possien 0 Reputation points
edited the question 2026-06-05T02:13:30.1766667+00:00
Kai-Ex 1,480 Reputation points Microsoft External Staff Moderator
2 answers

How do I start week groupings in pivot tables on a Sunday?

I am trying to group the dates on a pivot table in weeks beginning on a Sunday, e.g 08/03/2026 - 14/03/2026, 15/03/2026 - 21/03/2026, etc. I got it to work once but now it insists on starting the first range on the fist date in the data set and adding 7…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-03T05:01:18.13+00:00
Stephanie Batt 0 Reputation points
commented 2026-06-05T01:27:53.7766667+00:00
Huy-K 12,205 Reputation points Microsoft External Staff Moderator
3 answers

Copilot option is not working in some files

When i open a blank workbook Copilot is showing in the bottom right but while i am open an existing file it is not showing file is .xlsx,auto save is on ,internet is on and it is connected to cloud as well

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-03T08:05:45.76+00:00
edited the question 2026-06-05T01:20:28.2166667+00:00
Kai-Ex 1,480 Reputation points Microsoft External Staff Moderator
3 answers

Excel sheet that will time out when trying to edit

Excel sheet that will time out when trying to edit. How do i fix

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-04T20:18:06.49+00:00
Franklin, Shannel 0 Reputation points
answered 2026-06-04T22:13:39.0933333+00:00
Bulldog 2,285 Reputation points
1 answer One of the answers was accepted by the question author.

SharePoint Excel - I want columns to highlight-match the conditional format color rule that I have for the column next to it, with priority.

Hi! In SharePoint Excel, I currently have a checklist where Column D has conditionally format rule to turn green when the "true" value is clicked. I also have a rule where Column E turns yellow when the words "in progress" are…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-02T16:46:40.37+00:00
Paige G 20 Reputation points
accepted 2026-06-04T19:53:51.8333333+00:00
Paige G 20 Reputation points
3 answers

Excel 32bit - Entry Point Not Found

Getting this error when opening a certain file that has some macros that run on open. If i close the force close the application and reopen after the save, it opens fine. any ideas?

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-04T12:38:12.6633333+00:00
Guy 0 Reputation points
commented 2026-06-04T18:21:20.2433333+00:00
Guy 0 Reputation points
1 answer

An Excel formula randomly does not calculate

The below formula randomly does not calculate. This is a very recent occurrence, this exact formula in adjacent cells calculates correctly. The formula will calculate correctly when I select "Calculate Sheet," but it reverts to "0"…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-04T17:09:37.93+00:00
Gary Berndt 0 Reputation points
answered 2026-06-04T17:51:44.5433333+00:00
Marcin Policht 91,150 Reputation points MVP Volunteer Moderator
2 answers

I am unable to link the files from Excel because they are not appearing in the File Explorer window

I am unable to link the files from Excel because they are not appearing in the File Explorer windowRef Image.jpg

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-04T11:49:47.7366667+00:00
Nimesh 0 Reputation points
edited a comment 2026-06-04T15:29:59.6566667+00:00
Jess-Q 11,325 Reputation points Microsoft External Staff Moderator
2 answers

when i type DOB as 30/08/1955 it wont allow it I am not going to use calendar to scroll to this date! ?

when i type DOB as 30/08/1955 it wont allow it I am not going to use calendar to scroll to this date! ?

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-02T10:12:57.97+00:00
edited an answer 2026-06-04T14:37:11.34+00:00
Liora D 15,970 Reputation points Microsoft External Staff Moderator
2 answers

Issue syncing Excel project schedules with OneDrive for a local Dallas construction firm

Hello, Our team manages high-volume residential remodeling and framing jobs across the DFW metroplex. We use a shared Excel spreadsheet on OneDrive to update our daily timelines, but our field crews in Plano and Frisco keep hitting a sync conflict error…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-04T10:42:28.4133333+00:00
Zain Hamni 0 Reputation points
answered 2026-06-04T11:39:19.1533333+00:00
Henry-N 13,880 Reputation points Microsoft External Staff Moderator
2 answers

The calculator Paradox

Hello Group, I am currently building a grade-based salary calculator in Excel and could use some help with the formula logic. Salary Calculation.jpg I have a total Cost to Company (CTC) cell, along with fixed components like Basic Salary, HRA, and…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-04T09:56:53+00:00
Pratap Reddy 0 Reputation points
answered 2026-06-04T11:16:42.9166667+00:00
Liora D 15,970 Reputation points Microsoft External Staff Moderator
3 answers

how to reactivate a device in microsoft 365

how to reactivate a device in microsoft 365 that I deactivated

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-11-25T11:54:43.7833333+00:00
Vaggelis Lampropoulos 0 Reputation points
commented 2026-06-04T08:44:08.5966667+00:00
Stefan Blom 341.8K Reputation points MVP Volunteer Moderator
2 answers

How to fix error code Error Code: 0x803d0014?

I am trying to share an excel file with my team in the form of a link, but every time I attempt to go to File -> Share -> Share with People, Excel applications produced an Error Code: 0x803d0014. I've restarted, cleared my cache, signed out and…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-03T01:30:33.7366667+00:00
Blake Scott 0 Reputation points
commented 2026-06-04T06:09:35.7666667+00:00
Darren-Ng 10,620 Reputation points Microsoft External Staff Moderator
2 answers

How do you find an Excel problem reference

Need to locate the formula in Excel that has a problem refernce

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-02T14:44:10.76+00:00
Blake Hodges 0 Reputation points
commented 2026-06-03T22:38:38.49+00:00
Hendrix-C 17,145 Reputation points Microsoft External Staff Moderator
1 answer

=Filter pulling blank cells through as 1900-01-00 date instead of leaving cell blank

Good day I have a excel document I use to keep record of all training expire dates. As a tab I have a report page with =Filter to pull through dates that is expiring within the next month, but it keeps pulling blank cells through as 1900-01-00, through…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-02T08:05:56.8333333+00:00
Jacques F. Enslin 0 Reputation points
edited a comment 2026-06-03T16:23:20.66+00:00
Jess-Q 11,325 Reputation points Microsoft External Staff Moderator
2 answers

[Power Query] - New columns in Transform Sample File dont appear in Other Queries

Service: Power Query Editor in Power BI Context: I import a folder into Power Query. After making some steps in Transform Sample File and create new table in Other Queries folder, I need to go back Transform Sample File to add new custom columns.…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-02T11:02:18.4766667+00:00
Truong Duy Khiem 0 Reputation points
commented 2026-06-03T14:54:12.28+00:00
Liora D 15,970 Reputation points Microsoft External Staff Moderator
2 answers

Excel VBA Range.AutoFilter Object loses criteria when handling date values with the xlFilterValues operator

In Excel VBA the Range.AutoFilter object contains a Filters object, which in turn contains a number of Filter Objects that correspond to the columns in the range over which the filter is applied. Each Filter object contains a number of properties, as…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-05-29T16:03:01.63+00:00
Joe Machin 0 Reputation points
commented 2026-06-03T14:49:02.9966667+00:00
Alina Le 2,120 Reputation points Independent Advisor
3 answers

in my excel sheet I can not use xlookup since today morning yesterday i use it please help me

in my excel sheet I can not use xlookup since today morning yesterday i use it please help me Moved from: Windows for home | Windows 11 | Accessibility

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-03T11:43:03.1733333+00:00
OSL LOGISTICS PVT LTD 0 Reputation points
edited an answer 2026-06-03T12:14:37.92+00:00
Tamara-Hu 15,530 Reputation points Microsoft External Staff Moderator
3 answers

Excel Name Manager Won't Open for Certain Files

Several of my Excel files can't open the Name Manager window popup. Please let me know how to fix it. My Excel version is 365 for Enterprise.

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-06-02T03:37:28.61+00:00
Michael Yapriadi 0 Reputation points
commented 2026-06-03T01:13:13.2533333+00:00
Vivian-HT 16,595 Reputation points Microsoft External Staff Moderator