Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
asked 2025-02-19T15:55:53.96+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(12.8, 44%, 11%)' 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)
Annie (Student)
0
Reputation points
answered 2025-02-20T02:26:57.7833333+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,491
Reputation points
1 answer
If you attempt to paste link from encrypted(Internal sensitivity labelled) document (ex. excel), the option to paste link to Powerpoint as Microsoft Excel Worksheet Object is missing. The only option is a hyperlink.
If you attempt to paste link from encrypted(Internal sensitivity labelled) document (ex. excel), the option to paste link to Powerpoint as Microsoft Excel Worksheet Object is missing. The only option is a hyperlink.
asked 2025-02-14T06:10:36.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(80, 68%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOM%3C/text%3E%3C/svg%3E)
Owakiabul Molla
0
Reputation points
commented 2025-02-20T02:16:03.9966667+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(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jiajing Hua-MFST
14,805
Reputation points Microsoft Vendor
2 answers
How to enable the macro automatically on other computer
Suppose I sign an Excel macro with a certificate from a trusted Certificate Authority (CA). Will the macro automatically enable on another computer even if that computer does not have the CA's root certificate installed?
asked 2025-02-12T15:26:13.6133333+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(281.6, 35%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKR%3C/text%3E%3C/svg%3E)
Karthikeyan R
0
Reputation points
commented 2025-02-20T02:06:05.44+00:00
Jiajing Hua-MFST
14,805
Reputation points Microsoft Vendor
2 answers
Excel cannot print anymore, the other apps can
We have a Windows 10 Home edition. Office 365 is installed with the user who has a business standard license. Word, Outlook, .... works fine. And the user can print from the apps. The printer is located in the same lan. If we do the same in Excel we get…
asked 2025-02-11T12:54:14.33+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, 54%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kurt Stichelmans
661
Reputation points
commented 2025-02-20T02:04:00.3433333+00:00
Jiajing Hua-MFST
14,805
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Excel spreadsheet "Earned Sick Time Earned" formula help needed
Hello, I am a beginner at Excel. I am trying to create a spreadsheet to track Sick Time Earned. 1 hour earned for 30 hours worked. I need help completing this spreadsheet. What formula can I use to automatically calculate for column G and H (sick time…
Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
12,078 questions
Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
5,816 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
Windows 365 Business
Windows 365 Business
A Microsoft cloud operating system.
501 questions
Windows 10 Network
Windows 10 Network
Windows 10: A Microsoft operating system that runs on personal computers and tablets.Network: A group of devices that communicate either wirelessly or via a physical connection.
2,386 questions
asked 2025-02-17T15:50:42.9+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(28.799999999999997, 13%, 12%)' 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)
Accounting
0
Reputation points
edited a comment 2025-02-19T16:43:07.2333333+00:00
Accounting
0
Reputation points
2 answers
How to Disable the 'Premium Python Compute' Advertisement in Excel 365?
In recent versions of Excel I noticed a new diamond icon in the top right If you click this diamond you get an advertisement for "premium Python compute" How can I disable this advertisement? Steps to reproduce: Open Excel Open a…
asked 2024-10-22T06:17:59.0466667+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, 61%, 27%)' 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)
SomeUser89132
25
Reputation points
commented 2025-02-19T14:59:15.8766667+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(252.8, 63%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGP%3C/text%3E%3C/svg%3E)
Gerber Patrick BIT
0
Reputation points
0 answers
Help with IF Function in Excel
I need help with an IF function if that is what makes the most sense for the following scenario: In Sheet 1, I have a list of User IDs In Sheet 2, I have the same list of User IDs, but they could be listed multiple times in the same column In Sheet…
asked 2025-02-18T18:39:37.41+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(208, 46%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
EH_47
0
Reputation points
commented 2025-02-19T01:38:14.53+00:00
Emi Zhang-MSFT
27,961
Reputation points Microsoft Vendor
1 answer
Excel - Data validation rules
Hi All, How can I make a cell mandatory based on an answer in another cell? For example, I want cells in Column K to be mandatory IF the users replied "To be Assigned" in Cell C. Thanks in advance!!
asked 2025-02-17T15:54:56.7833333+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(179.20000000000002, 72%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFG%3C/text%3E%3C/svg%3E)
Felipe Giordano
20
Reputation points
edited an answer 2025-02-19T00:54:07.0933333+00:00
Emi Zhang-MSFT
27,961
Reputation points Microsoft Vendor
1 answer
Fix Run-time error '1004'
How to I remove the Run-time error '1004', Method 'Name' of object 'Addln' failed. This Visual Basic for Applications window pops up every time I open Excel immediately after the new file appears, when I invoke "New" from the File menu and…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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.
4,275 questions
asked 2024-12-29T17:50:10.1066667+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(179.20000000000002, 24%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
David Herring
0
Reputation points
commented 2025-02-18T20:53:27.74+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(124.80000000000001, 63%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Next Step
0
Reputation points
0 answers
How to Retrieve Local and Web Paths of an Excel Workbook from OneDrive using JavaScript API
A OneDrive folder has been synchronized on a local machine, allowing workbooks to be opened directly from this folder. The local and web paths can be obtained using the Info => Copy path and Info => Copy local path options, as highlighted in the…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
1,321 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
1,045 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.
4,275 questions
asked 2025-02-18T16:52:25.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(19.2, 40%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Kashif Bashir Bhatti
36
Reputation points
asked 2025-02-18T16:52:25.0666667+00:00
Kashif Bashir Bhatti
36
Reputation points
2 answers
One of the answers was accepted by the question author.
I am having a trouble with the Autosave with one specific Microsoft excel Spreadsheet on my windows 11 computer
I am having a trouble with the Autosave with one specific Microsoft excel Spreadsheet on my windows 11 computer. I have never changed the way the shared spreadsheet is used, however a few days ago, the autosave ceased to function. I do not believe the…
asked 2025-02-15T15:32:58.3533333+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, 42%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECF%3C/text%3E%3C/svg%3E)
Christopher Fox
20
Reputation points
accepted 2025-02-18T15:19:40.94+00:00
Christopher Fox
20
Reputation points
1 answer
giving a user access to a shared file , approving access still not working
giving a user access to a shared file , approving access still not working
asked 2025-02-17T15:34:04.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(259.20000000000005, 41%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Chrishaun Douglas
0
Reputation points
answered 2025-02-18T10:06:43.4466667+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(313.6, 51%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EED%3C/text%3E%3C/svg%3E)
Emily Du-MSFT
50,326
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Using Power automate to email when a date is due to expire in 2 weeks
Hi all, So, I'm trying to create a flow that sends an email 2 weeks prior to a due date expiring. I've got the file on my one drive and have setup a power automate, but it is blank at the moment, have tried a few times to get this working myself with…
asked 2025-02-17T16:19:51.8466667+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(124.80000000000001, 69%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFV%3C/text%3E%3C/svg%3E)
Fabian Vaughan
20
Reputation points
accepted 2025-02-18T08:13:45.76+00:00
Fabian Vaughan
20
Reputation points
2 answers
Regarding the problem that Excel mouse wheel cannot scroll smoothly
I have installed mouse smoothing software, but Excel still does not support smooth scrolling with the mouse wheel. I have tried many methods in the community, but still cannot solve it. I hope someone can help me solve this problem. Thank you.(The…
![](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(230.39999999999998, 75%, 32%)' 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)
1 answer
Excel Macros Not Running on Company Server
Hello, I have an issue where Excel macros work fine on my PC, but when the file is stored on my company’s server, macros are blocked. Excel shows a security risk warning in pink, and the "Unblock" checkbox is missing from the file…
asked 2025-02-17T13:31:03.38+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, 99%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEJ%3C/text%3E%3C/svg%3E)
EULOGIO JIMENEZ JIMENEZ
0
Reputation points
answered 2025-02-18T00:56:11.28+00:00
Emi Zhang-MSFT
27,961
Reputation points Microsoft Vendor
1 answer
Excel Macros Not Running on Company Server
Hello, I have an issue where Excel macros work fine on my PC, but when the file is stored on my company’s server, macros are blocked. Excel shows a security risk warning in pink, and the "Unblock" checkbox is missing from the file…
asked 2025-02-17T13:31:03.38+00:00
EULOGIO JIMENEZ JIMENEZ
0
Reputation points
answered 2025-02-18T00:56:11.28+00:00
Emi Zhang-MSFT
27,961
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
How to sum up to a certain value
My employee time cards are on excel spreadsheets. I'm trying to auto sum the employee's hours into a cell up to 40 hours. Then have the hours greater than 40 be put into a "overtime" cell. For example, Sum G10:M10 into N10 up to 40 then any…
asked 2025-02-17T17:53:04.56+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(89.60000000000001, 94%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAO%3C/text%3E%3C/svg%3E)
Andy Orford
20
Reputation points
commented 2025-02-17T18:01:37.7566667+00:00
Andy Orford
20
Reputation points
1 answer
Excel scatter chart does not keep the selected data
I have attached a pdf file which details the process I follow in excel which leads to the scatter plot data range being just one point rather than the many points I selected. I will also summarize the process with words in the post-script (P.S.) I have…
asked 2023-11-19T20:17:04.8133333+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, 41%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELS%3C/text%3E%3C/svg%3E)
L S
5
Reputation points
commented 2025-02-17T16:45:52.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(48, 99%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Smith, Carter
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Microsoft Excel Formatting Rules
Hi All, I'm trying to set up a rule on excel to color the whole row if a cell within this row contains a specific value. For example, if cell A3 contains the phrase "To be assigned" - I want the entire row A (and not only cell A3) to be painted…
asked 2025-02-17T13:44:06.0033333+00:00
Felipe Giordano
20
Reputation points
accepted 2025-02-17T15:50:47.2566667+00:00
Felipe Giordano
20
Reputation points
1 answer
Syncing Excel Macro files in OneDrive is ruining my life
I have recently bought a new Windows laptop. When I download XLSM files and run them and their macros, everything is great. I run them and save them, and everything is wonderful. But, then there is this torturous process where OneDrive has to figure out,…
asked 2025-02-16T08:04:50.7466667+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, 70%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJO%3C/text%3E%3C/svg%3E)
JT Overstreet
0
Reputation points
commented 2025-02-17T07:40:44.5833333+00:00
Jiajing Hua-MFST
14,805
Reputation points Microsoft Vendor