3,694 questions with Excel-related tags

Sort by: Updated
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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
asked 2025-02-18T18:39:37.41+00:00
EH_47 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
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…

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
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,226 questions
asked 2025-02-15T15:32:58.3533333+00:00
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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,817 questions
asked 2025-02-18T11:54:39.8966667+00:00
Sokoban 1,041 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

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
422 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,226 questions
asked 2025-02-17T15:34:04.6+00:00
Chrishaun Douglas 0 Reputation points
answered 2025-02-18T10:06:43.4466667+00:00
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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
asked 2025-02-17T16:19:51.8466667+00:00
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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
asked 2025-02-14T04:37:39.86+00:00
庞九权 0 Reputation points
answered 2025-02-18T05:29:02.71+00:00
庞九权 0 Reputation points
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!!

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
asked 2025-02-17T15:54:56.7833333+00:00
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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,759 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,759 questions
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

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
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,759 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,759 questions
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
0 answers

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 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
Accounting 0 Reputation points
edited the question 2025-02-18T00:46:41.5933333+00:00
ZhoumingDuan-MSFT 15,970 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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
asked 2025-02-17T17:53:04.56+00:00
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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
asked 2023-11-19T20:17:04.8133333+00:00
L S 5 Reputation points
commented 2025-02-17T16:45:52.03+00:00
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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
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,…

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
asked 2025-02-16T08:04:50.7466667+00:00
JT Overstreet 0 Reputation points
commented 2025-02-17T07:40:44.5833333+00:00
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…

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
asked 2025-02-15T22:29:29.38+00:00
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…

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
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,226 questions
asked 2025-02-04T20:09:38.5833333+00:00
Noah Greisman 0 Reputation points
edited a comment 2025-02-17T05:52:24.6466667+00:00
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

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,759 questions
asked 2025-02-15T06:22:24.7933333+00:00
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.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,226 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,817 questions
asked 2025-02-14T14:47:11.97+00:00
Zoltan Csirke 0 Reputation points
commented 2025-02-17T02:30:13.6266667+00:00
Yanli Jiang - MSFT 29,041 Reputation points Microsoft Vendor
1 answer

Is there a reason why my recent files would be missing in excel?

Hello. There is a user that I work with and when they open Excel, they don't see any documents recently opened in the "Open" tab. The screenshot below is what is normally shown but it's no longer there. I've checked the display settings and…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,914 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
asked 2024-03-21T19:27:29.05+00:00
Kareem 85 Reputation points
commented 2025-02-17T01:52:13.3833333+00:00
Jim Smithheisler 0 Reputation points