API for Microsoft Excel is not working properly.
Hey, I am connecting you on behalf of Pabbly Connect. Within our integration, we have set up an action event "List Worksheet" which is currently throwing an error and we are not able to use a list worksheet. Here is the URL for your…
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…
how to get rid of script error in excel web query
I am using ms excel 2016 standard and OS is windows 10. I have been trying to use web query feature in excel to download a data from a website but have been getting scripting error. how i can avoid that. Also i guess my excel tries to open the web page…
How to write dynamic array references inside a XLOOKUP and FILTER functions
Dear community, I will appreciate your help, advice and support with the following: I have a master file with all of the residents contributions for maintenance and repairing on our house group. From this master file, I'm looking up for each resident…
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).…
I would like to export all tracked changes in my excel sheet
I have an Excel spreadsheet in which I made changes and turned on track changes. I can do a 'Show changes', but I would like to export all those changes to a new Excel sheet. Do you have an code that can do that?
frequent error when refreshing pivot table
When refreshing a Pivot table that is created from another worksheet, I get: An unexpected error occurred (file'pcminorobjcoll.inl', line 109, function 'PCMinorObjectCollection[class PCProperty.class NameHashSupport]::SetNameAndUpdateCollection') This…
Excel macro recording for formatting a comment in a cell not possible
I'm trying to record a macro in Excel while formatting a comment for a cell. But only the text content will be recorded. Changing of background color, pattern e.g. are not recorded. The button for stop recording is dimmed when I enter the dialogue box…
How to fix Microsoft.NET Framework "Value Does not fall within the expected range" error
Hello, I have an Excel file linked with powerpoint for +50 graphs and tables. It was working fine until I linked the cell below: ="Average Deal Cycle is " & J3 & " Days" with some formatting, such as color and borders. Now,…
Can't interact with Excel because of hidden dialog box.
Hidden dialog box keeps Excel from operating properly. I've tried alt-tabbing the dialog does not show up. When I try to shut Excel down using the task manager since close it normaly I get a dialog box stating "You cannot close Microsft Exel…
When creating a new excel sheet, how can some specific cells appear in another sheet?
Good day all, I need your help for a project please. Pls find the link if this can help: https://1drv.ms/x/s!AtYjpXHdhdJHmF9DcIIsgyPob3bk?e=PZvUW3 When creating sheet P.O No.1, we want to have the below cells to automatically appear in sheet P.O…
Export scheduling poll results to an excel spreadsheet
I am scheduling a meeting using the scheduling poll for over 15 people and over 30 options. Is there a way to export the results to an excel spreadsheet (similar to the Doodle export function)?
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…
Deleted question
Deleted question
Muita dificuldade de acesso ao Microsoft Authenticador
Preciso entrar no Microsoft Authenticador mas, após digitar a senha, o aplicativo pede para acessar o proprio aplicativo e digitar o código que se encotra lá, a mesma coisa ocorre quando seleciono outra maneira de entrada, ou seja, fico num looping…
Fidelity active pro trader will not load due to extention error
I have tried multiple ways to download the fidelity active pro trader on my new laptop with no success. The picture states the issue and google hasn't helped me resolve this so I'm open to any help. Thank you all
Excel threads not spreading across cores
I’m using excel to crunch massive amounts of data. I was previously using my 8th gen I7 laptop but this wasn’t able to run the spreadsheet any more, despite making lots of efficiencies with formula and macros (my macros are extremely basic). I have now…
Create an add-in for Excel for a listening server
From an Excel file, I want to call a bunch of APIs protected with Microsoft Entra ID. The multifactor authentication is enabled as explained in this Microsoft document. So, my idea is from an Excel spreadsheet to call the Entra ID and access the data.…
Excel files are opening as read only
Hello everyone. Excel files are opening as Read Only for multiple users, this is the same whether the files are opened from the local machine or a network share location. Opening other documents from the same location using Word and PowerPoint are…
Add trusted location via reg file unsuccessfully.
I have added a trusted location via reg file. However, it doesn't seem to be successful but cause the location is greyed out AND it doesn't have the expected effects of a trusted location. What should I do to be able to add trusted location by…