Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,088 questions
1 answer
Excel, group, date, part of weekdays.
I have a date and have to write down three to four weekday times every week. The week should be highlighted in colour. How can I achieve this? What is the best way to fill it in? Count up over the day. Autofill. The goal. I'll use formulas now. The…
asked 2025-01-18T13:30:22.57+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(134.4, 96%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
Noah Aas
525
Reputation points
commented 2025-01-19T01:28:21.4433333+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,236
Reputation points
1 answer
Excel, group, date, part of weekdays.
I have a date and have to write down three to four weekday times every week. The week should be highlighted in colour. How can I achieve this? What is the best way to fill it in? Count up over the day. Autofill. The goal. I'll use formulas now. The…
asked 2025-01-18T13:30:22.57+00:00
Noah Aas
525
Reputation points
commented 2025-01-19T01:28:21.4433333+00:00
Barry Schwarz
3,236
Reputation points
1 answer
MS Graph WorkbookApplication/Calculate API With Application Permissions
Hello, We are interested in using the API call here: https://learn.microsoft.com/en-us/graph/api/workbookapplication-calculate with Application permissions. It is ran on an internal server without needing a user auth workflow. A similar thread is here:…
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
12,799 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,088 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,158 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(246.4, 78%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
1 answer
When I close Excel, an empty Excel window opens again.
I recently upgraded from Excel 2007 to the 2021 version and since then, every time I use Excel and close it after saving, an empty Excel window automatically opens again. I have tried updating and reinstalling Excel, but the problem persists. I am…
asked 2023-03-21T00:05:31.69+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, 47%, 10%)' 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)
재경 이
5
Reputation points
commented 2025-01-18T01:19:47.3866667+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(38.4, 8%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Harsha Sundi
0
Reputation points
3 answers
Problem opening spreadsheets in Excel 2016 since Win 11 24H2 upgrade
We have just updated to Win 11 24H2 and use stand alone Office 2016 Standard. We are experiencing problems with opening Excel spreadsheets from hyperlinks and File Explorer where a ~$ temp file pre-exists against the file we are trying to open. Excel…
asked 2024-11-22T11:11:37.2566667+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(73.60000000000001, 90%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
Alan Lee
15
Reputation points
answered 2025-01-17T21:05:46.8066667+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(262.40000000000003, 38%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVN%3C/text%3E%3C/svg%3E)
Vinh Nguyen
0
Reputation points
1 answer
How to make a complete iframe in One Drive for Charts in excel?
Hi, I'm trying to embed some parts of my excel in my html page. When I click three dots to embed my file and then try to customize it, the iframe is not completed: <iframe width="402" height="346" frameborder="0"…
asked 2025-01-16T18:59:19.8666667+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, 6%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
Payam Taherirostami
0
Reputation points
edited a comment 2025-01-17T20:46:00.7966667+00:00
Payam Taherirostami
0
Reputation points
0 answers
Issue on Dialog when adding Custom Functions into Office Excel Add-In
We are developing an Excel Add-In of a TaskPanel type, (Typescript). I need to use a Dialog (using DialogApi) in order to authenticate the user into an Azure B2C service. this part works fine, we use the messages to login and refresh tokens as…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,088 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,158 questions
asked 2025-01-17T18:34:49.4633333+00:00
Jose Morquecho
0
Reputation points
asked 2025-01-17T18:34:49.4633333+00:00
Jose Morquecho
0
Reputation points
1 answer
ASP.NET web site fail to critical error in ETL of Excel file
I have a website with a single web page on ASP.NET that you need to upload a file in Excel to a folder within the website, extract its contents to insert the data into a table in a database in SQL Server. When testing its operation on the production web…
asked 2025-01-15T21:44:17.87+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, 20%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENJ%3C/text%3E%3C/svg%3E)
Nelson Javier Bahamon Parrado
0
Reputation points
commented 2025-01-17T18:18:46.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(262.40000000000003, 46%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Albert Kallal
5,336
Reputation points
0 answers
Single value expected, but array delivered
Hi @ all! This formula should spill all data from January 2025 and expand this array by 3 (3 = WEEKDAY from January 1st, 2025). But it only works if the @ is…
asked 2025-01-17T11:47:25.6966667+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, 9%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBG%3C/text%3E%3C/svg%3E)
Boris Georgi
0
Reputation points
asked 2025-01-17T11:47:25.6966667+00:00
Boris Georgi
0
Reputation points
2 answers
Error when importing .csv-file to Outlook calendar
Hi! I want to import a number of calendar events from Excel (.csv) to the Outlook calendar. I created the .csv file myself and made three simple columns to test: Subject (A), Start Date (B), and End Date (C), along with two test rows with values. In…
![](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(51.2, 14.000000000000002%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOE%3C/text%3E%3C/svg%3E)
1 answer
Excel 365 crashes after Macro to create a new workbook
The organization runs a workbook with macros that will create a new workbook from a template we created. After a VBA subroutine using a form for the end user to enter the desired file name and testing the characters of the name (to omit slashes, 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,838 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,088 questions
asked 2025-01-16T15:05:28.1233333+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, 57.00000000000001%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
mary b
0
Reputation points
answered 2025-01-17T07:26:53.3366667+00:00
Emi Zhang-MSFT
27,081
Reputation points Microsoft Vendor
1 answer
Security Excel
After browsing several forums, I find that the only real security for an Excel file is encryption with a password. Unfortunately, a person who knows the password can change it after having access to the file. Is it possible with VBA to put a password in…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,088 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,158 questions
asked 2025-01-15T22:08:56.6533333+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(220.8, 74%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
Orkit
45
Reputation points
commented 2025-01-17T04:26:51.0133333+00:00
Kristian Holm Buch
0
Reputation points
1 answer
Why is my excel file deleting color after mandatory restarts after Windows 11 install?
I have the 2016.018324.20092 version of excel. I created a large file (764 lines) of data to illustrate a data entry problem. I highlighted about one-third of the lines and cells in colors to match up to the type of problem. I saved the file. Windows…
asked 2025-01-15T18:25:14.1166667+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(169.60000000000002, 60%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Chornyak, Cindy (she/her)
0
Reputation points
commented 2025-01-16T20:39:34.9066667+00:00
Chornyak, Cindy (she/her)
0
Reputation points
1 answer
MS Excel Drop Downs/DataValidation
Hi, for a short period of time we had the luxury in MS Excel that a drop down selection (Data Validation Drop Down and not in a table) would automatically jump to the correct first letter selection when we started typing in the cell with data validation.…
asked 2025-01-10T10:07:52.1766667+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, 15%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHF%3C/text%3E%3C/svg%3E)
Horak, Franz
0
Reputation points
edited an answer 2025-01-16T09:27:27.6033333+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
13,135
Reputation points Microsoft Vendor
1 answer
Win11 24H2 Update Causing Selenium VBA Scripts to Fail
After updating to Windows 11 24H2, Selenium VBA scripts are unable to open the browser and return runtime error -2146232576 (80131700). The .NET Framework version is 4.8.1. Both the ChromeDriver and Selenium Basic versions are up to date, and they have…
asked 2025-01-11T00:55:03.8066667+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, 49%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
Don Wright
0
Reputation points
commented 2025-01-16T09:04:59.08+00:00
Emi Zhang-MSFT
27,081
Reputation points Microsoft Vendor
2 answers
Checkbox Issue 365Beta
The latest Update for 365 Insider Beta has screwed the checkboxes. Try to refer to them in a cell, which is not in the same row as the checkbox. Nothing happens with the cell, when you change the checkbox value, even "Calculate" doesnt…
asked 2025-01-12T20:58:56.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(275.2, 33%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
OEE
5
Reputation points
commented 2025-01-16T09:04:42.74+00:00
Emi Zhang-MSFT
27,081
Reputation points Microsoft Vendor
1 answer
How can I fill cells corresponding to two date values?
I'm trying to figure out a formula to fill cells with colour corresponding to date ranges and task to show Red, Amber, Green across a timeline.
asked 2025-01-15T13:38:28.48+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(44.800000000000004, 44%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHY%3C/text%3E%3C/svg%3E)
Helen Young
0
Reputation points
commented 2025-01-16T08:01:35.8033333+00:00
Emi Zhang-MSFT
27,081
Reputation points Microsoft Vendor
1 answer
Excel-Personal.xlstart will not open/start
I have tried all of this and also had IT repair my excel and nothing has worked. My Personl.xlstart does not open when I open a new excel file. It does not show in my Visual basic-project. To open the file you may follow these steps in Excel 2016. …
asked 2025-01-15T20:05:07.1+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(32, 46%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Martin, Sherrise (WMC)
0
Reputation points
answered 2025-01-16T07:52:01.6233333+00:00
Emi Zhang-MSFT
27,081
Reputation points Microsoft Vendor
1 answer
Can't see who is in a shared excel file
Hello - I can no longer see the initials of people who are in a shared excel file in the upper right hand corner. Other users can see MY initials when I'm in the file, but I can't see theirs. Anyone know how to fix this?
Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
5,503 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,680 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,088 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,069 questions
asked 2025-01-15T16:35:23.62+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, 46%, 20%)' 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)
Dee Cee
0
Reputation points
edited an answer 2025-01-16T02:21:40.3166667+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, 5%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Robin Sheng-MSFT
5,525
Reputation points Microsoft Vendor
1 answer
How guest users can access semantic model from their tenant and create reports in excel online
We have a user A who is part of Tenant X , Guest Account has been created for user in Tenant Y . We have a semantic model in Tenant Y , to which user wants to connect from excel online using Tenant X Credentials from excel online . Currently when we…
asked 2025-01-14T20:38:26.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(38.4, 21%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Shreyas Rastogi
225
Reputation points
answered 2025-01-15T07:45:38.21+00:00
Jiajing Hua-MFST
13,135
Reputation points Microsoft Vendor