merge excel files
How to merge several Excel file into one worksheet in Excel?
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…
formula in excel to simulate lunch and breaks
formula in excel to simulate lunch and breaks
Creating Forms with Dropdown options using Excel
I am creating a request form using Excel. I want to be able to allows users to select one of the options from the drop-down or fill in the necessary information. Can I create a drop down that allows users to select from the list or fill in relevant…
Excel File in Use - wrong user
Hi guys, There is an Excel file created by a user (say User_A). (This is the only file from many other Excel files that behaves this way.) Normally when an Excel file is already opened the next user can see who opened that file from a popup…
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…
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…
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…