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…
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…
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…
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…
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…
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…
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
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…
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…
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!!

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…

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…

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…
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…
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…
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,…
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…

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…
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
Runbooks issue
SharePointExcelAutomation code does not run all the way. Copilot cannot give solution for errors. We need someone from Microsoft Support.