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…
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…
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…
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…