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)
Python dans excel
Does anyone know how to install Tkinter on Python in Excel ?
Python in excel timeout error acts as 30 secs when typing 1800+ seconds
So I'm trying to do long calculations in one cell with python in excel, but i bumped into the problem that, when I type 1800 seconds or more as the timeout delay in the settings, it automatically acts as 30 seconds. It's the same for all numbers higher…
![](https://learn.microsoft.com/en-us/media/profile/user-copilot.png)
"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 ?
Date grouping issue pivot table - Excel
I am encountering difficulties adding grouping to date columns in a PivotTable within the attached Excel file. When attempting to drag any date column to the row area, the expected grouping by month, year, or quarter does not appear. Manually clicking…
import pdf to excel
why does only show up by the data tb to click get external data, not to get data, and get the option to get a pdf file?
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…
disable Ease of access feedback options
Hello, We use Office 365 version 2006 (build 13001.20384) and we want to disable the ease of access option "Provide feedback with sound" for all out users. This option is default enabled. In Office 365 (version 2002 build 12527.20278) this…
why the left column of taskgroup is reduced in customui backstage with excel 2013
Hello everyoneI have a problem in excel 2013 with my additional menu in the bakstage (CustomUI)the left column is not resized customUI> <backstage> <tab id="tabb202401" label="mes tutos sur youtube"…
When I create a module in VBA and I'm typing a line of code, it just closes, any solutions?
I'm creating a simple registration system in Excel, I open Visual Basic normally, but when I click on "insert" and then "Module", after 10s Excel closes.
how to get the PIVOTBY function working on my excel
how to get the PIVOTBY function working on my excel?
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
Excel Differences between two worksheets but worksheets have dependent columns
I need to find a formula that supports the ability to highlight differences between two worksheets. Each worksheet has the same two columns. Those two columns are dependent of each other in order for the information to be correct. I need the formula to…
Excel - VBA macro code to pull outlook files by spesific date range in spesific folder and save as today date
Hi everyone, Need advise from the expert here. I am trying to pull outlook files but the results it extract all the file in that spesific folder. I am trying to only pull all the files on today date. May i know what code should i put so that the VBA code…
How do I change the default font for notes in Excel?
The default font for a New Note in Excel is 'Bold' and I want to set the default to 'Regular'.
How to renew Microsoft 365 Developer licence
I had subscribed to the Microsoft 365 Developer Program, but my subscription has expired and was not renewed. I am seeking assistance to resubscribe to the program
VBA function FileDateTime() is off by 1 hour.
Assuming current date is 06/29/2024 (PDT) and timezone is Los Angeles, the following example is correct. Dim MyStamp ' Assume TESTFILE was last modified on June12, 2024 at 4:35:47 PM. ' Assume English/U.S. locale settings. MyStamp =…
Default File Name when Save As in an Excel Template
I have an already created excel template. I would like to change or update the default suggested file name when you click save as when you open the template from a new excel sheet. This is very similar to updating the Title field in the Properties…
training courses for vBA programing in Toronto Canada
Hi Can you please advise where can I take VBA training courses accredited by Microsoft. It should be located in Toronto Canada. Thank you Adriana
Do I need to be certified in MS Excel Associate before being certified in MS Excel Expert?
I want to have a certificate for MS Excel Expert. However, I am not sure of its requirements or if there are any pre-requisites. I do not have any MS certifications yet. Do I need to take MS Excel Associate or any other certification/exam first? …