3,975 questions
3,975 questions with Microsoft 365 and Office | Excel | For business | Windows tags
1 answer
Can I have a dropdown list and original data in the same cell?
I have a dropdown list in a cell to choose the frequency of an action. My dropdown has Weekly, Bi-Weekly, Monthly, Quarterly, Semi-Annually, and Annually. Some users want to be able to add their own frequency. Can I have a dropdown with choices, but…
Microsoft 365 and Office | Excel | For business | Windows
asked 2025-06-01T19:45:00.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(67.2, 57.99999999999999%, 16%)' 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)
Tugboat Business Solutions
0
Reputation points
commented 2025-06-09T02:16:46.6333333+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, 1%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Dora-T
2,275
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
How to fix copy and cut features to clipboard
, when I copy or cut in excel a pop up appears saying (We could not copy the content to the clipboard, it is in use by another application. You can still paste your content within this workbook but it will not be available in other applications). Then…
Microsoft 365 and Office | Install, redeem, activate | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
3,975 questions
Windows for business | Windows Client for IT Pros | User experience | Other
asked 2023-10-08T15:38:25.2833333+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(118.4, 46%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
andrea france
45
Reputation points
answered 2025-06-08T07:37:15.0666667+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(3.2, 25%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Phynix
0
Reputation points
1 answer
Additional Rankif
Hello, Additional formula of Rankif in excel. Thank you…
Microsoft 365 and Office | Excel | For business | Windows
3,975 questions
asked 2025-06-07T18:45:23.7066667+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, 21%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
DAISY ROSE ORDONEZ
0
Reputation points
answered 2025-06-08T03:11:52.9866667+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,746
Reputation points
1 answer
Ratings and Reviews Not Visible Inside Excel Store
Hello, We have published a new add-in, AI Agent for Excel. We noticed that the ratings and reviews submitted by users are visible on the AppSource web page: https://appsource.microsoft.com/en-us/product/office/WA200008627?tab=Overview However, they do…
Microsoft 365 and Office | Excel | For business | Windows
3,975 questions
![](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, 32%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
1 answer
How to Fix Instellisense in Excel Power Query Editor?
In a specific workbook, Intellisense has stopped working in power query, no suggestions appear, when i start typing, except if a define it previously. The issue pertions to specific workbook(s) What causes this error? Is there a way to fix it?
Microsoft 365 and Office | Excel | For business | Windows
3,975 questions
asked 2025-05-29T12:55:20.2633333+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(80, 91%, 17%)' 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)
Szabolcs Phraner
0
Reputation points
commented 2025-06-05T09:44:36.8933333+00:00
riny
745
Reputation points
Volunteer Moderator
1 answer
Can't find the "pivotSource" and "pivotOptions" description in the http://schemas.microsoft.com/office/drawing/2012/chart schema
Hello Microsoft Team! I have a problem with an XML schema, I can't find anywhere in the schema the following XML tags: "pivotSource" and "pivotOptions", and their further description. I tried here:…
Microsoft 365 and Office | Excel | For business | Windows
3,975 questions
![](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, 0%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
0 answers
Macros in Excel
Can you not upload a Excel file with macros to trouble shooting VBA code in the macros?
Microsoft 365 and Office | Excel | For business | Windows
3,975 questions
asked 2025-05-28T17:51:32.82+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(233.6, 82%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Mike Griffith
0
Reputation points
commented 2025-06-04T13:18:09.55+00:00
Luis Angel Ñañez Llanos
431
Reputation points
0 answers
Excel Connection to Power BI Data always requires SSO. How to save credentials?
I have some data that I have put together in Power BI, and I am trying to access in Excel, using a connection to the data: Every time I open the file and try to refresh the data, Excel asks to confirm the Microsoft account SSO. Is there any way to save…
Microsoft 365 and Office | Excel | For business | Windows
3,975 questions
asked 2025-06-03T13:37:28.35+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(188.79999999999998, 63%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Chris Snyder
0
Reputation points
asked 2025-06-03T13:37:28.35+00:00
Chris Snyder
0
Reputation points
2 answers
Excel can not open
My excel can not be open. I faced ms excel can't open or save any more documents because there is not enough available memory or disk space but my C drive has 100GB space. I deleted my temp file and reinstall office 365 but did not open excel. please…
Microsoft 365 and Office | Development | Other
4,395 questions
Microsoft 365 and Office | Excel | For business | Windows
3,975 questions
asked 2021-09-14T09:03:22.99+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(291.2, 16%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHH%3C/text%3E%3C/svg%3E)
HMP Harshana
1
Reputation point
commented 2025-06-02T18:29:13.5466667+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, 66%, 31%)' 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)
Kajoe
0
Reputation points
2 answers
Standard user not able to add excel com add ins? with out Admin privilege.
Hi, For my project, I need to install an Excel COM add-in as a standard user without requiring administrative privileges. I created a batch script that writes the necessary registry entries under HKEY_CURRENT_USER, including CLSID, ProgID, and the path…
Microsoft 365 and Office | Excel | For business | Windows
3,975 questions
asked 2025-05-29T06:03:04.5533333+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, 96%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
srinivas bandam
0
Reputation points
commented 2025-06-02T10:34:06.5966667+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, 61%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
TiNo-T
2,540
Reputation points Microsoft External Staff
Moderator
0 answers
splitting a value in a cell to other 6 cells
A formula needed. Dear sir, please help me with an optimised formula. I'm using MS Excel 2021. According to the table attached herewith: If I fill column named "SCALE DOWN" with less than 30 marks, then the rest of the columns (not 'TOTAL'…
Microsoft 365 and Office | Excel | For business | Windows
3,975 questions
asked 2025-05-31T14:53:23.0966667+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(275.2, 84%, 36%)' 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)
Venkata Suri Lanka
0
Reputation points
commented 2025-06-01T13:20:32.8366667+00:00
Barry Schwarz
3,746
Reputation points
1 answer
How to open a third party app from within a Excel cell?
In Excel, I want to be able to click on a hyperlink in the cell (or the cell itself) and have a third party app (RingCentral) open. How do I do that?
Microsoft 365 and Office | Excel | For business | Windows
3,975 questions
asked 2024-01-22T18:28:12.17+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(86.4, 91%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Troy Marsh
0
Reputation points
commented 2025-05-31T14:27:52.5966667+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, 45%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Dennis Cain
0
Reputation points
2 answers
Otra cuenta de tu organización ya inició sesión en este dispositivo. Intentalo de nuevo con otra cuenta.
mi office no me deja ingresar Correlation Id: 76bf7b82-af8c-5640-bd8c-c46d8a8d3b01 Timestamp: 2023-05-08T13:02:52.000Z DPTI: 0eb6fbfed0064a71e4f84f24bf3e853acbd48b6bed4f2bcdab4f7aef376e507e
Microsoft 365 and Office | Excel | For business | Windows
3,975 questions
asked 2023-05-08T13:09:11.0033333+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, 32%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
Maria Victoria Mosquera
10
Reputation points
commented 2025-05-31T11:34:13.6+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, 77%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Mariana Garro
0
Reputation points
0 answers
Excel scripts will not run. "We ran into an issue. Please try launching the taskpane again"
Hello: I cannot get any excel scripts to run. Even one as simple as typing "Hi" into a cell, see below, returns "We ran into an issue. Please try launching the taskpane again" Macros are enabled in trust center and I have tried…
Microsoft 365 and Office | Excel | For business | Windows
3,975 questions
![](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, 35%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
0 answers
Continuing Problem Opening Excel and Files
Have been down this road 2xs. Excel and files won't open, win 10, always updated, already repaired/reinstalled excel 2xs, doing it again. What in the heck is going on? We PAY for this, it's not FREE. Was is there a fix or what? Seems stupid to have to do…
Microsoft 365 and Office | Excel | For business | Windows
3,975 questions
![](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, 76%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
1 answer
Ctrl+Enter Not Working in Excel
I am using a brand new Mac M3 with Parallels and my ctrl+Enter keys are not working as they used to in my 10-year-old Mac. Specifically, I used to be able to use ctrl+Enter to propagate results to all cells in a range, but this is no longer working.…
Microsoft 365 and Office | Excel | For business | Windows
3,975 questions
asked 2024-06-18T06:31:02.0033333+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(288, 98%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Nicola Cardi
0
Reputation points
commented 2025-05-28T04:21:24.8333333+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, 69%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Mehabr Gulart
0
Reputation points
1 answer
How do I save only tabs selected in a list box in a single pdf?
I have a list box that contains the names of all the tabs in the Excel workbook and the following macro to do a print preview: Sub print_sh() Dim i As Long, c As Long Dim SheetArray() As String With ActiveSheet.ListBox1 For i = 0 To .ListCount - 1 If…
Microsoft 365 and Office | Excel | For business | Windows
3,975 questions
asked 2025-05-20T15:56:24.25+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, 41%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Dennis Psota
0
Reputation points
commented 2025-05-22T12:42:53.97+00:00
Barry Schwarz
3,746
Reputation points
0 answers
Problems with SQL Server Data Connections in PowerPivot
Microsoft Windows 11 Enterprise, Version 10.0.26100 Build 26100 Excel Version 2108 Build 14332.21040 When executing queries against SQL Server 2012 databases in PowerPivot using the default SQLOLEDB provider that contain temp tables (#<tablename>),…
Microsoft 365 and Office | Excel | For business | Windows
3,975 questions
asked 2025-05-21T18:11:48.24+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, 56.00000000000001%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jeff
0
Reputation points
commented 2025-05-21T21:12:36.6266667+00:00
Erland Sommarskog
122.3K
Reputation points MVP
Volunteer Moderator
0 answers
Azure DevOps Office® Integration 2019 extension on mac
we have identified that the Azure DevOps Office® Integration 2019 extension is not supported on macOS so we require for that any alternative third party tool on mac OS
Microsoft 365 and Office | Excel | For business | Windows
3,975 questions
asked 2025-05-21T11:23:10.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(198.4, 91%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Ashish Patil
0
Reputation points
asked 2025-05-21T11:23:10.7766667+00:00
Ashish Patil
0
Reputation points
1 answer
Want to make it so that a Pivot will show how many days a vehicle is used monthly rather than total journeys
So the scenario I am in in that my company has multiple vehicles which can be taken as part of a car pool. Some cars are more popular to be taken than others. At the moment, on a spreadsheet we manually record the journey number, date of journey, time…
Microsoft 365 and Office | Excel | For business | Windows
3,975 questions
![](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(304, 13%, 39%)' 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)