Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,093 questions
1 answer
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
commented 2025-01-22T10:35:39.18+00:00
Boris Georgi
0
Reputation points
1 answer
Can the print settings of EXCEL continue to be used in WORD
When I transfer an EXCEL table to a WORD document, the original EXCEL table that can print two pages only has one page in WORD. If I pull it in WORD, all the content can be displayed, but the header set in EXCEL cannot be displayed. What should I do?
asked 2025-01-21T14:22:13.5566667+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(128, 38%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESI%3C/text%3E%3C/svg%3E)
sect Inner
125
Reputation points
answered 2025-01-22T06:01:35.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(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,520
Reputation points Microsoft Vendor
1 answer
Cannot Save-As Any Excel File As Of This Morning
I cannot save-as any new Excel files as of this morning (1/21/2025). Attempts to save-as existing Excel files as new files is also not possible. What can I do to remedy this?
asked 2025-01-21T17:47:11.5466667+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(214.4, 25%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHP%3C/text%3E%3C/svg%3E)
Harrison Pierce
0
Reputation points
answered 2025-01-22T02:03:09.2+00:00
Emi Zhang-MSFT
27,166
Reputation points Microsoft Vendor
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
15
Reputation points
answered 2025-01-21T22:12:33.4466667+00:00
Peter Louvel
0
Reputation points
1 answer
Why does Excel freeze when copying large ranges and how can I fix it?
When attempting to copy a large range, Excel freezes and gradually consumes all available memory (16 GB) over a ten minute period. This issue occurs even in safe mode and repairing Office 365 has not helped. However, when running Excel as administrator,…
asked 2024-06-11T20:16:26.86+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, 85%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERN%3C/text%3E%3C/svg%3E)
Roger Novak
5
Reputation points
commented 2025-01-21T19:42:56.27+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(278.4, 66%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
George
0
Reputation points
1 answer
One of the answers was accepted by the question author.
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…
![](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)
1 answer
One of the answers was accepted by the question author.
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…
1 answer
How to insert Sharepoint Document ID in a document (Word, Excel...)?
Hi, I enabled the Document ID in Sharepoint so each document have a unique ID. I would like to insert this Document ID in documents (Word, Excel...) but I do not have access to this property of the document (it does not exist in File > Info >…
asked 2024-06-27T08:10:58.9333333+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(182.40000000000003, 16%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDJ%3C/text%3E%3C/svg%3E)
David JAOUEN
0
Reputation points
commented 2025-01-21T13:35:38.14+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, 77%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Kari Puttonen
0
Reputation points
2 answers
One of the answers was accepted by the question author.
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)
20
Reputation points
accepted 2025-01-21T12:28:13.7333333+00:00
Chornyak, Cindy (she/her)
20
Reputation points
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
commented 2025-01-21T09:39:42.0133333+00:00
Emi Zhang-MSFT
27,166
Reputation points Microsoft Vendor
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,844 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,093 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
commented 2025-01-21T09:36:37.2833333+00:00
Emi Zhang-MSFT
27,166
Reputation points Microsoft Vendor
1 answer
I cannot re-open an xcel file
My xcel file won't reopen. I used Hide for 3 columns then closed the file. Now I can't re-open the file.
asked 2025-01-21T03:28:09.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(313.6, 0%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
John Scott
0
Reputation points
answered 2025-01-21T08:37:28.5666667+00:00
Emi Zhang-MSFT
27,166
Reputation points Microsoft Vendor
1 answer
I cannot re-open an xcel file
My xcel file won't reopen. I used Hide for 3 columns then closed the file. Now I can't re-open the file.
asked 2025-01-21T03:28:09.48+00:00
John Scott
0
Reputation points
answered 2025-01-21T08:37:28.5666667+00:00
Emi Zhang-MSFT
27,166
Reputation points Microsoft Vendor
1 answer
Autosave Onedrive and Sharepoint Online files option missing completely
Hello, I can't seem to be able to enable the Autosave button. It doesn't show up at all in the Quick Access Toolbar in Excel. But it also doesn't show up as an option to check in Excel->File->Options->Save. I am logged on my OneDrive Account…
asked 2025-01-20T14:41:13.7533333+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, 83%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIM%3C/text%3E%3C/svg%3E)
Ioana M
0
Reputation points
answered 2025-01-21T08:02:50.4333333+00:00
Jiajing Hua-MFST
13,520
Reputation points Microsoft Vendor
1 answer
repair error when opening excel file, all screenshots in the excel file are removed
Hello, When opening an excel file, the following error comes up: "Removed Part: /xl/metadata.xml part with XML error. (Metadata) Catastrophic failure Line 2, column 426. Removed Feature: Worksheet properties from /xl/workbook.xml part…
asked 2025-01-20T07:48:34.8533333+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, 38%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MP
0
Reputation points
answered 2025-01-21T05:24:43.73+00:00
Jiajing Hua-MFST
13,520
Reputation points Microsoft Vendor
1 answer
repair error when opening excel file, all screenshots in the excel file are removed
Hello, When opening an excel file, the following error comes up: "Removed Part: /xl/metadata.xml part with XML error. (Metadata) Catastrophic failure Line 2, column 426. Removed Feature: Worksheet properties from /xl/workbook.xml part…
asked 2025-01-20T07:48:34.8533333+00:00
MP
0
Reputation points
answered 2025-01-21T05:24:43.73+00:00
Jiajing Hua-MFST
13,520
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,533 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,710 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,093 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,094 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
commented 2025-01-21T03:08:10.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(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,685
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
commented 2025-01-20T09:19:52.6466667+00:00
Jiajing Hua-MFST
13,520
Reputation points Microsoft Vendor
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
commented 2025-01-20T09:17:48.8+00:00
Jiajing Hua-MFST
13,520
Reputation points Microsoft Vendor
1 answer
After win 11 24h2 upgrade unable to open / export protected excel documents
After upgrading users to Win 1124h2 from Win 1022h2 they are unable to export / open protected .xml files in excel on office2019. Have turned off enabling protected view in trust center settings, added file path in trust center settings, uninstalled,…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,844 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,093 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
10,485 questions
asked 2025-01-09T20:10:58.9933333+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(278.4, 61%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
Kyle Cullinan
0
Reputation points
commented 2025-01-20T09:14:46.0933333+00:00
Jiajing Hua-MFST
13,520
Reputation points Microsoft Vendor