how to remove auto group window
how to remove this, I don't want this auto group and add another window too many function and lag, too slow when i want to change my work book. if i want another group from a-b to a-c? y create auto group?
Office Script to delete all rows in a table receives timeout error
I have an office script that is designed to delete all rows in a table. When I run it for 50 or less rows it runs with no problem, but times out when I test it for a larger number of rows (~600). Once this project is live I anticipate the table will…
The insertWorksheetsFromBase64() Excel api is missing capability to insert hidden worksheets
Currently we are utilizing insertWorksheetsFromBase64() api for our plugin to insert worksheets into excel workbook. Our team would like to insert HIDDEN worksheets using insertWorksheetsFromBase64() Excel api. Is it feasible from your end to expose…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
How to fix "an operation that uses the driver could noet be compleated. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query." while using Inventory Cube in Escel
Hello, We're trying to troubleshoot the error that is occurring for one of our user's when he tries to run Inventory Cube within Excel. We've already tried reinstalling Office, running Excel in safe mode, changed the settings in order to unblock DDE,…
Can i add another value in this PivotFilter statement?
Hi, Can i add another value (e.g. TLOG_MMF_COR_0003) in the below statement 'Type:=xlCaptionDoesNotBeginWith' where existing value1 'ATLOG_MMF_0003' is there already: ============================================ …
Excel close and reopen - Faulting module name: mso20win32client.dll
Hi, on some computers in my company Excel sometimes closes and reopens without presenting any error messages. Sometimes changes to the file are preserved and sometimes they are lost. Our Excel is part of Microsoft 365 Business standard. These computers…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
How to fix SSMS import excel issue for Dell/Windows?
Hi, Im starting to learn how to code in SQL and want to start creating my own projects. Im trying to import my own excel file (64 bit) to the SSMS server but am unable to do so because of this image in the attached. Can anyone help with a solution to…
![](https://techprofile.blob.core.windows.net/images/YC3KiAudCk6A0I6NB9vOyA.png?8DA953)
Problems with VBA
This will look for current year and month folder problem one is it keeps cresting the 2 folders over and over again, Also would like for it to save the file with the value of a cell like if I put address in it would save in the current month file with…
Need to stop office apps from EVER opening in a browser on my PC. Was told to post here by answers.microsoft
I need to stop files (Excel files on SharePoint/OneDrive primarily) from opening in a browser on my PC. I feel like I've tried everything. All the advice I get is to click on the ellipses and select "open in desktop app", or go to SharePoint…
VBA codes using Named Ranges is not working since migration to O365
We recently migrated to O365 and we have several spreadsheets that are legacy items that transpose information from one sheet to another (info from input sheet to a table that is on another sheet for upload and is reconfigured to a different format) . …
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
System.ArgumentException: Value does not fall within the expected range.
I am making an Excel Addin in C# in Visual Studio. I have already made another simpler Addin and installed it with no problem. But on this one I am getting the following error: “Name: ExcelAddin_RSMeansV.2 From: file:///C:/Users/jstebbins/Desktop/Excel…
An issue with the data model is preventing Microsoft Excel from launching workbook
Hi Friday I worked in one of my Excel folders that are running with queries and connections (Data Model) My sheet worked perfectly on Friday and when I returned today to the office and want to refresh my data I got the message that an issue with the data…
Excel/Powerpoint send as attachment feature not working correctly in new Outlook
When sending emails from excel/powerpoint as attachment, the email doesn't get delivered to user in new outlook. The same can be done in old outlook.
Excel SCRIPT not running in P.automate
A P.automate flow uses an Excel script to create a chart but the line where Getpoints is used causes an error in online execution. Desktop script execution works w-o…
clarify the complex date function
hi, i cannot make sense of this function, could you please clarify it to me: =IF(OR(MONTH(Input!$B$7)<3,MONTH(Input!$B$7)>9),DATE(YEAR(Input!$B$7)+(MONTH(Input!$B$7)>3),2,28),DATE(YEAR(Input!$B$7)+(MONTH(Input!$B$7)>9),9,30)) especially:…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
Workbook.refreshAllDataConnections() is not supported in Power Automate.
Dear all, I have an excel sheet with an active connection which I am able to refresh to get the newest data. Now I've got another PowerAutomate Flow which is working fine with a script inside this Sheet to send me via Teams numbers which I want to be…
Data from a csv file to excel, date is in MM/DD/YYYY format, region set as Australia
Newbie here so simple language please. Data was transferred as a csv file into excel file. I have subsequently entered more data. I have noticed the date of the imported data is in MM/DD/YYYY format even though settings, region, language and cell format…
"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."
One of the users receive this error. is this issue at our end or at microsofts ?
Glitches in Excel formulas
02.07.24 Fd Wge Cost Bgt 24-25 - 10 (version 8 13.05.24.xml Hi, We have a problem with the attached spreadsheet. The details are as follows: Daily Spreadsheet : "Monday" Wages Q2985 "Minimum" formula for Mondays only works with…
Python Function limit chars?
I was super excited to see Python was being supported in MS Excel. I have been waiting for this functionality for a very long time. I was pretty sad to see the limitation of only 8,415 characters per python script. Is there any way to increase this? I…