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…
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
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…
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
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.
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…
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…
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…
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…
Excel "3D Map" feature error: 3D Maps encountered an error while contacting Microsoft Bing mapping services. Functionality may be limited. (Status Code: 4)
Hello, I am running into an issue with Excel application where I am no longer able to use the "3D Map" feature. I used to use the search bar to load the feature but now when i do that i am faced with the following error: 3D Maps…
How to get a small picture to pop up when hovering over a cell in excel?
Creating a spreadsheet with fabric names and trying to get a small picture of each fabric color to pop up when hovering the cell.
merge excel files
How to merge several Excel file into one worksheet in Excel?
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…
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…