Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,615 questions
1 answer
Why are my Ctrl - and Ctrl + shortcuts (delete and insert cells) not behaving properly
I have multiple versions of the same file. I thought that the latest ones got corrupt at some point and Ctrl - wasn't working. All it did was delete the cell contents instead of deleting the cells. So i started testing for the latest non corrupt file and…
asked 2024-05-20T06:00:19.39+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, 48%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Abhinav Jain
5
Reputation points
commented 2024-05-23T04:49:55.31+00:00
Abhinav Jain
5
Reputation points
0 answers
Programmatically read restricted excel file
I have a series of Excel's that are protected by the business. I have the required permissions to view the file manually however I would like to create a programmatic way to extract the data from these excels. I have tried using Python to read and…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,615 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.
3,652 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,671 questions
asked 2024-04-05T11:44:17.3133333+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(307.2, 65%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rando
5
Reputation points
commented 2024-05-22T15:18:53.94+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(105.60000000000001, 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)
DANIEL COHEN
0
Reputation points
1 answer
Files that are encrypted through the sensitivity label.
Hello Please i need your help on this issue. The newest version of Excel 16.85 is having permission issues with opening encrypted Excel files I've opened the Excel file on my MAC that is in my downloads folder. This issue looks to be on all files…
asked 2024-05-16T18:58:07.4566667+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(70.4, 17%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIN%3C/text%3E%3C/svg%3E)
Iniobong Nkanga
1,691
Reputation points
commented 2024-05-22T08:31:07.1366667+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
6,745
Reputation points Microsoft Vendor
0 answers
How can I get the status of calculation request when using Workbook /calculate endpoint?
I am using the Microsoft Graph API endpoint /calculate for workbook recalculation, but it does not provide a way to poll for the status of the calculation asynchronously. After making a POST request to this endpoint, it initiates the calculation process…
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,103 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,047 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.
3,652 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,671 questions
asked 2024-05-21T08:36:06.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(208, 6%, 30%)' 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)
Sankalp
0
Reputation points
edited the question 2024-05-22T08:18:56.05+00:00
Jiajing Hua-MFST
6,745
Reputation points Microsoft Vendor
22 answers
Microsoft should FIX - "Errors were detected while saving (filename)"
Microsoft must FIX this decade long bug with appears out of nowhere and has ruined a lot of months of work of my life. Please fix the below error message. It is even appearing in latest Office 2019. "Errors were detected while saving (filename).…
asked 2020-07-27T18:53:59.793+00:00
Asha Kanta Sharma
96
Reputation points
commented 2024-05-21T16:17:32.6933333+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, 50%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Steve Lipsman
30
Reputation points
0 answers
Excel 16.85 is having permission issues
Hello Please i need your help on this issue. The newest version of Excel 16.85 is having permission issues with opening encrypted Excel files I am able to open the file while on 16.84 then when I update to the latest update 16.85 I would get the…
asked 2024-05-20T20:32:55.65+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(310.4, 73%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
IBN
0
Reputation points
commented 2024-05-21T08:15:06.4633333+00:00
Emi Zhang-MSFT
23,031
Reputation points Microsoft Vendor
0 answers
Interop.Excel always saving in default path even specifying the path manually for Office 365
Trying to create an Excel file using Office.Interop.dll (15.0.4795.1001).But it is taking the default file path instead of the path which set manually. if (extensionObj != null) { relativeExcelPath =…
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,501 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.
3,652 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,671 questions
asked 2024-05-20T11:08:56.84+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, 59%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Venkatachalam S1
0
Reputation points
asked 2024-05-20T11:08:56.84+00:00
Venkatachalam S1
0
Reputation points
3 answers
Excel cells maximum sum
Good evening to all, In excel in cells F8:F9 we have the numbers 17 and 11 respectively (sum 28), in cells M8:M9 we have the numbers 14 and 9 respectively (sum 23) and in cells T8:T9 we have the numbers 17 and 14 respectively (sum 31). I am looking for…
asked 2024-05-08T21:45:29.8733333+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, 6%, 40%)' 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)
Νικόλαος Γιαννέλος
0
Reputation points
commented 2024-05-17T07:18:53.6366667+00:00
Jiajing Hua-MFST
6,745
Reputation points Microsoft Vendor
1 answer
New version of excel is having permission issues with opening some files
Hello Please i need help on this issue. The newest version of Excel 16.85 is having permission issues with opening encrypted Excel files. Had to roll back to the older 16.84 version for it to work.
asked 2024-05-15T16:58:34.16+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, 76%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI8%3C/text%3E%3C/svg%3E)
IniobongNkanga-8038
266
Reputation points
commented 2024-05-16T18:04:13.4433333+00:00
IniobongNkanga-8038
266
Reputation points
4 answers
One of the answers was accepted by the question author.
Can not type into cells of excel file embeded from OneDrive
Dear Team,I have generate embeded code that allow to type into cells. I see it OK in the PREVIEW mode. (Preview mode included in customizing embed code Screen) The image as…
asked 2024-03-21T02:29:06.85+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, 28.999999999999996%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Premium Premium
35
Reputation points
edited an answer 2024-05-16T06:18:51.06+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(150.4, 19%, 24%)' 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)
King Chan
0
Reputation points
0 answers
Microsoft Report Builder Creating Blank Column
Hello, I have a report I am editing in Microsoft Report Builder. This is for Epicor... When I tell Epicor to view the report in Excel, it comes up with a blank column in between A and C. So no matter how I rearrange, column B is just blank. But when I…
asked 2024-05-14T16:21:25.26+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(310.4, 15%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Michele Pelley
0
Reputation points
asked 2024-05-14T16:21:25.26+00:00
Michele Pelley
0
Reputation points
1 answer
Cannot read excel file which is in using adls using load_workbook of openpyxl in databricks
Cannot read excel file which is in using load_workbook of openpyxl but can read if copied to dbfs
![](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, 53%, 27%)' 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)
![](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(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
1 answer
Highlight blank cell in excel post fixed date
Blank cell to be highlighted post certain dates. For example: Cell B3 is blank which needs to be highlighted after 10-May-24. Pls note, B3 cell will remain blank till due date and numeric data supposed to be filled before 10-May-2024
asked 2024-05-04T12:27:28.4033333+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(188.79999999999998, 31%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Jayesh Gangawane
0
Reputation points
commented 2024-05-10T07:05:22.9866667+00:00
Emi Zhang-MSFT
23,031
Reputation points Microsoft Vendor
0 answers
Why is Excel OM v5.3 unable to work consistently on my computer?
This is for a college class I'm taking, and I don't know what else to do. I've tried uninstalling all of Microsoft Office 365 and then reinstalling. I've tried uninstalling Excel OM v5.3 and reinstalling. This is the message I'm getting: "The item…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,615 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.
3,652 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,671 questions
asked 2024-05-09T21:39:29.1133333+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(22.400000000000002, 24%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Adnane Rhoulam
0
Reputation points
commented 2024-05-10T03:42:44.7266667+00:00
Adnane Rhoulam
0
Reputation points
2 answers
Greyed out drop down lists
In Excel, when I click on a drop down list on the tool bar (fill color, Sort & Filter, Auto Sum, etc) all the drop down options are greyed out & I cannot click on any of them.
asked 2024-05-06T20:27:40.9833333+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(284.8, 69%, 37%)' 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)
Sally Curtis
0
Reputation points
answered 2024-05-07T08:47:03+00:00
Sani Garba
1
Reputation point
1 answer
Embedding part of Excel file from Onedrive in iframe stopped working
Hello, For a while now I share different parts of an Excel on my OneDrive in different iframes. That stopped working since last April, all different frames show the same: the Excel as a whole, with tabs my iframe code is as follows: …
asked 2024-05-04T09:29:16.4266667+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(92.8, 86%, 18%)' 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)
Martijn Staphorsius
0
Reputation points
answered 2024-05-06T08:18:12.64+00:00
Jiajing Hua-MFST
6,745
Reputation points Microsoft Vendor
0 answers
excel data streamer
Im facing a problem regarding data streamer in excel i my laptop when i add in data stream extension it show like that my laptop specification is Edition Windows 11 Home Single Language Version 22H2 Installed on 17-Mar-23 OS…
asked 2024-05-03T04:52:30.6233333+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(192, 90%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES0%3C/text%3E%3C/svg%3E)
secondary 04 phone
0
Reputation points
asked 2024-05-03T04:52:30.6233333+00:00
secondary 04 phone
0
Reputation points
0 answers
Excel script for filling cells within a specified range with a specific fill color if any cell within the range is selected
Using scripts in Excel (NOT VB macros), I need to be able to fill any cell within a specified range with a specific color if any cell within the range is selected ("clicked on"). Note that the spreadsheet will have different columns that need…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,615 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,633 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.
3,652 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,671 questions
asked 2024-03-31T14:28:49.82+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(227.2, 26%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%3C/text%3E%3C/svg%3E)
Robin Theodore
0
Reputation points
edited the question 2024-05-02T17:06:50.7833333+00:00
Robin Theodore
0
Reputation points
1 answer
When trying to save changes in an excel file, I get a message "You are no longer connected to the file. Another user may have removed you from it, or saved over it."
I keep getting a message when I try to make any changes to a shared excel file. The message says, " You are no longer connected to this file. ANother user may have removed you from it, or saved over it." I have saved changes in this file before…
asked 2022-09-30T17:29:38.563+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(227.2, 73%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKJ%3C/text%3E%3C/svg%3E)
Kaur, Jaspreet
1
Reputation point
commented 2024-04-30T19:16:44.6233333+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(67.2, 53%, 16%)' 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)
EForston
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Excel can't convert xml file to xml table when there's only one row
Hello, I get a response XML from a service. When the XML contains multiple rows of data it imports into Excel fine but if there is only one row of data the headers nothing imports. Both XML files are…
![](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(217.60000000000002, 91%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)