19,118 questions
19,118 questions with Microsoft 365 and Office | Excel | For business | Windows tags
1 answer
Office LTSC 2024 (32-bit) on Windows 11 VDI - "Non-Genuine" Message Despite Successful KMS Activation
Hi everyone, I'm encountering an issue with Office LTSC Standard 2024 (32-bit) on a Windows 11 23H2 VDI environment. Despite what appears to be a successful KMS activation, a "non-genuine product" message is displayed when I launch applications…
Microsoft 365 and Office | Excel | For business | Windows
![](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(160, 78%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
![](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, 10%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
3 answers
Hide & Display Values
Hi, I would like to display the Data 2 hide values in S$XXXX.XX. What is the value to input in TYPE: box? Thank you
Microsoft 365 and Office | Excel | For business | Windows
19,118 questions
asked 2025-08-11T07:22:01.64+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(115.19999999999999, 50%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDY%3C/text%3E%3C/svg%3E)
Darren Yong
0
Reputation points
answered 2025-08-12T02:51:00.5466667+00:00
Darren Yong
0
Reputation points
1 answer
My excel stop auto calculation
Hi Microsoft Team, I have been using an excel model for 4 years with no problem, but for the last 3-4 days, the formula in my file has stopped calculating automatically. I have tried create a blank excel file with only one simple formula to test (this is…
Microsoft 365 and Office | Excel | For business | Windows
19,118 questions
asked 2025-08-07T12:22:36.67+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(67.2, 99%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENV%3C/text%3E%3C/svg%3E)
Nghiep Vuong
0
Reputation points
commented 2025-08-12T01:39:48.98+00:00
Nghiep Vuong
0
Reputation points
1 answer
How to create drop down that only functions when another cell is not blank?
Hi, I have a drop down that is dependent on the selection from another drop down cell. When the user selects the Sheet Item Number (20044290 or 20044297) from the drop down in cell S17, it will then populate the respective drop down items (per the…
Microsoft 365 and Office | Excel | For business | Windows
19,118 questions
asked 2025-08-08T16:30:39.2666667+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(92.8, 93%, 18%)' 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)
Scott R Pelton
0
Reputation points
commented 2025-08-11T21:52:49.03+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(172.8, 53%, 26%)' 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)
Barry Schwarz
3,836
Reputation points
1 answer
Microsoft Excel data not showing sometime.
We use MS 365 office below version on server 2012 R2, one of the user reported us that, once she open any .xls .xlsx .csv or even word file, data in not shown randomly but format of the cell / column is there. I rebuilt her profile and removed the…
Microsoft 365 and Office | Excel | For business | Windows
19,118 questions
asked 2025-08-11T18:39:30.28+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(176, 70%, 27%)' 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)
Amandeep Singh
0
Reputation points
edited an answer 2025-08-11T21:10:11.03+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(256, 74%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIN%3C/text%3E%3C/svg%3E)
Ian-Ng
1,645
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
How do i convert this to a normal date and time for easier viewing
2025-07-03T08:00:00.000-04:00+ISO 8601 standard I need to format this in a normal date/time format for easy viewing
Microsoft 365 and Office | Excel | For business | Windows
19,118 questions
asked 2025-08-08T11:56:26.4266667+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(41.6, 49%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECW%3C/text%3E%3C/svg%3E)
Carrie Ward
20
Reputation points
commented 2025-08-11T20:15:44.5066667+00:00
Barry Schwarz
3,836
Reputation points
4 answers
Populating three non-consecutive days of the week for the month
I'm wanting to find a formula for populating Tuesdays, Thursdays, and Saturdays for the entire month, then also generating their respective dates. The purpose would be to track donations made to our group on those specific days and dates.
Microsoft 365 and Office | Excel | For business | Windows
19,118 questions
asked 2023-12-12T18:05:28.85+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(294.40000000000003, 81%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDA%3C/text%3E%3C/svg%3E)
dennis armour
0
Reputation points
answered 2025-08-11T15:17:07.1666667+00:00
p45cal
0
Reputation points
2 answers
One of the answers was accepted by the question author.
How to fix an issue where a black bar is covering my sheet tabs in Excel
In Excel within Citrix, a black bar appears at the bottom of the window, obscuring the sheet tabs. This issue occurs across multiple workbooks and machines, making it difficult, but not impossible, to navigate between sheets. I have attached a screen…
Microsoft 365 and Office | Excel | For business | Windows
19,118 questions
asked 2025-08-11T09:53:40.88+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(16, 97%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECO%3C/text%3E%3C/svg%3E)
Connor Otterbeck
0
Reputation points
accepted 2025-08-11T15:08:21.7233333+00:00
Connor Otterbeck
0
Reputation points
1 answer
One of the answers was accepted by the question author.
my excel sheet is being constantly blocked!
I have been having this issue for months now but my patience is running thin. I am paying for a business license to be able to use Python on excel. This way, I got an email address with @onmicrosoft.com. I am logged in in my excel. I did go to trust…
Microsoft 365 and Office | Excel | For business | Windows
19,118 questions
asked 2025-08-08T10:06:09.4166667+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(236.8, 72%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIP%3C/text%3E%3C/svg%3E)
Iulia Pintrijal
20
Reputation points
commented 2025-08-11T14:31:43.53+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(160, 14.000000000000002%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
Alina-Le
1,040
Reputation points Microsoft External Staff
Moderator
3 answers
How can I create a column in a power query that inserts a formula into table after you close and load the power query?
I would like to create a table from a power query that contains a column "TotQty" and in this column I want it to contain a SUMIFS formula. Here is the actual formula that I would like for the table to contain "=SUMIFS([Qty],[Item…
Microsoft 365 and Office | Excel | For business | Windows
19,118 questions
asked 2025-08-10T17:30:01.9366667+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(9.6, 65%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Cynthia McNeill
0
Reputation points
edited an answer 2025-08-11T14:29:25.37+00:00
p45cal
0
Reputation points
1 answer
Not getting the Auto save slider in excel but getting in powerpoint
Hi team I am not getting the auto save slider option in excel while i get the same in power point i tried everything not able to get the auto save slide in excel . Please suggest or help
Microsoft 365 and Office | Excel | For business | Windows
19,118 questions
asked 2025-08-06T14:07:23.4266667+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(22.400000000000002, 81%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
Tuhin Bhowmick
0
Reputation points
commented 2025-08-11T14:02:14.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(278.4, 99%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Allison-H
715
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
how do I convert seconds to minutes:seconds
I want to convert this number 261 seconds to minutes in this format but I can't remember how I did this :( 12:04:21 AM
Microsoft 365 and Office | Excel | For business | Windows
19,118 questions
asked 2025-08-11T12:28:58.6433333+00:00
Carrie Ward
20
Reputation points
accepted 2025-08-11T13:52:41.2033333+00:00
Carrie Ward
20
Reputation points
1 answer
I want an alternative of google sheet's import range and query function in excel online or dektop which helps to transfer data on real time or if not real time than while rfreshing into another sheet and vice versa for only limited data
I have 71 sheets in excel one is master sheet and other are branches sheets, in which whenever any branch will update their data in their own sheet it should reflect into concern sheet of another workbook that is master sheet and when a column is updated…
Microsoft 365 and Office | Excel | For business | Windows
19,118 questions
asked 2025-08-06T07:12:52.6933333+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(144, 57.99999999999999%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECP%3C/text%3E%3C/svg%3E)
Chandra Prakash Nagar
0
Reputation points
commented 2025-08-11T09:21:51.63+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(144, 10%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
Rin-L
1,755
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
New laptop/excel. When I open a file from our accounting system that was a web page format it is opening in a really small font. Old laptop/excel did not do this. I checked Option General new file font and it is much bigger
I got a new laptop/Excel. When I save a file from out accounting system, it saves as excel/web page. BEFORE I would just open in excel, say it is OK format and the file looked fine. Now, it is opening with a really really small font. I looked at…
Microsoft 365 and Office | Excel | For business | Windows
19,118 questions
asked 2025-08-06T18:24:59.93+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(83.2, 10%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Karen Perreman
20
Reputation points
accepted 2025-08-11T11:31:14.11+00:00
Karen Perreman
20
Reputation points
2 answers
Every time I open excel it's closing due to an error that is preventing it from working correctly. Always asks to repair and keeps closing
Every time I open excel it's closing due to an error that is preventing it from working correctly. Always asks to repair and keeps closing
Microsoft 365 and Office | Excel | For business | Windows
19,118 questions
asked 2025-08-07T11:04:52.31+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(249.60000000000002, 99%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPG%3C/text%3E%3C/svg%3E)
Pedro Gomes
0
Reputation points
commented 2025-08-11T08:39:33.15+00:00
Pedro Gomes
0
Reputation points
3 answers
How to format negative values on chart axes?
I have configured the Number format for the chart axis as [>999999999]\$#.00,,,"B";[>999999] \$#.00,,"M"; \$#.00, which correctly displays positive values. However, assistance is needed in handling negative values since I'm…
Microsoft 365 and Office | Excel | For business | Windows
19,118 questions
asked 2025-08-07T15:44:50.05+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(163.2, 47%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Varad Sadre
0
Reputation points
commented 2025-08-11T13:24:46.1+00:00
Varad Sadre
0
Reputation points
1 answer
Office 365 not able to print documents with tickbox's inserted in to the sheet
When we are attempting to print any excel documents with a tick box inserted in to the sheet we aren't able to get a preview of the document and this then also grey's out the ability to be able to print the document this also includes when attempting to…
Microsoft 365 and Office | Excel | For business | Windows
19,118 questions
asked 2025-08-07T16:12:04.7766667+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(153.6, 69%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Nigel Rooms
0
Reputation points
edited the question 2025-08-11T10:00:04.2333333+00:00
Nigel Rooms
0
Reputation points
2 answers
Why is Excel selecting a different cell when I click?
often, The cell above the one I am trying to edit is selected. Re-starting Excel seems to fix it, but this is happening pretty frequently
Microsoft 365 and Office | Excel | For business | Windows
19,118 questions
asked 2025-08-08T11:43:07.79+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(272, 74%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Turner, Dean
0
Reputation points
answered 2025-08-11T12:07:26+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(41.6, 1%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
Tamara-Hu
1,015
Reputation points Microsoft External Staff
Moderator
1 answer
excel sheet
How to find excel sheet created date. I wanted to know how to check excel sheet created date.
Microsoft 365 and Office | Excel | For business | Windows
19,118 questions
asked 2025-08-11T12:01:36.29+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(195.2, 30%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Naveen Kumar Tejavath
0
Reputation points
answered 2025-08-11T12:17:22+00:00
HansV
460.6K
Reputation points MVP
Volunteer Moderator
1 answer
One of the answers was accepted by the question author.
Excel - Date / Time Formatting Issue
Hello, I am not very experienced with Excel, but I have managed to create a spreadsheet that logs my working hours. Every time I enter a new time, the cell automatically reformats to date & time. The formulae still display the correctly but it is…
Microsoft 365 and Office | Excel | For business | Windows
19,118 questions
asked 2025-08-11T13:12:59.78+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(99.2, 76%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAI%3C/text%3E%3C/svg%3E)
Ainslie Innes (James Slater & Co)
0
Reputation points
accepted 2025-08-11T13:47:06.9766667+00:00
Ainslie Innes (James Slater & Co)
0
Reputation points