Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
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-18T22:52:27.5+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,411
Reputation points
1 answer
Earned Sick Time Spreadsheet Sick Time Used?
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,077 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,811 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.
500 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
answered 2025-02-18T22:42:40.67+00:00
Barry Schwarz
3,411
Reputation points
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,274 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,316 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,274 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
0 answers
SPMT - Make CSV - PowerShell
Hi I want to migration from FileServer to SharePoint/Teams files. I have SharePoint Migration Tool (SPMT) and I need to make a CSV file there for migration task. I mean Bulk Migration CSV , to migrate content using a list of sources and destination. I…
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,246
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
0
Reputation points
accepted 2025-02-18T08:13:45.76+00:00
Fabian Vaughan
0
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 - 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
answered 2025-02-18T05:06:41.3433333+00:00
Emi Zhang-MSFT
27,871
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
![](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,871
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,871
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
![](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
1 answer
Links in an Excel file stored on OneDrive do not refer to local file
I have an Excel file that is created locally and backed up on OneDrive. I need to be able to give this Excel file to someone else who will not have access to my OneDrive file, and who may not even have a OneDrive account. Any links from one worksheet to…
asked 2025-02-15T22:29:29.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(99.2, 81%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
Kelley Weston
0
Reputation points
edited an answer 2025-02-17T06:34:11.89+00:00
Emi Zhang-MSFT
27,871
Reputation points Microsoft Vendor
1 answer
Accessing Windows Server folder within Sharepoint/OneDrive for Excel Workbook links
I have several data sets stored within an Isilon Server that is hosted on an in house wifi network. Some of which are are stored in .CSV and some in .XLSX formats. I want to be able to link that data to a commonly accessed excel file that is shared among…
asked 2025-02-04T20:09:38.5833333+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, 23%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENG%3C/text%3E%3C/svg%3E)
Noah Greisman
0
Reputation points
edited a comment 2025-02-17T05:52:24.6466667+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(57.599999999999994, 33%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXX%3C/text%3E%3C/svg%3E)
Xyza Xue_MSFT
28,306
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Power Query error 0xC0000005
User reported experiencing an error (0xC0000005) when running Power Query on two different queries in Excel LDAP settings have been verified correct
asked 2025-02-15T06:22:24.7933333+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(0, 76%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Simpson, Alan
20
Reputation points
accepted 2025-02-17T03:29:30.3166667+00:00
Simpson, Alan
20
Reputation points
0 answers
Runbooks issue
SharePointExcelAutomation code does not run all the way. Copilot cannot give solution for errors. We need someone from Microsoft Support.
asked 2025-02-14T14:47:11.97+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(60.8, 12%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZC%3C/text%3E%3C/svg%3E)
Zoltan Csirke
0
Reputation points
commented 2025-02-17T02:30:13.6266667+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, 17%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYJ%3C/text%3E%3C/svg%3E)
Yanli Jiang - MSFT
29,041
Reputation points Microsoft Vendor