How to Default name of the user who signed in to an Excel field
Hi, I want to default name of the user who Signed in to an excel field and make it non editable. If user not signed in, prompt as 'Please Sign In'. Please advice how to do it. Regards, Sudheer.
how to enable macro of excel worksheet received via email
How to make an excel file a trusted document so that I can enable the marcos?
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
Resize table using VBA
Hello, I currently use the following code in order to copy data to another worksheet. However, when I eliminate rows on the original worksheet, the range of the table for the second worksheet remains the same when I run the macro. I was wondering if…
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…
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…
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…
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 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).…
![](https://techprofile.blob.core.windows.net/images/81e5464fcaed4a37af5c90db5808e813.png)
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…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
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 =…
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…
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.
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…
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…
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
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
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
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…
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.
![](https://techprofile.blob.core.windows.net/images/4ONyhCP8dk62EjqroG-32w.png?8DAC8A)
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: …
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…