"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 ?
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)
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?
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…
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? …
I dont see automatization card in excel
private pc
using conditional sumproduct, trabspose
Hi I have a huge data base and need to sort and filter some results I need to calculate " The labour" working hours in multiple tables of ONE SHEET, as…
Office Client - Excel
Hello Please i need your help on this issue. A number of problems browser clocking with certain programs/data refresh is not working in excel and trying to attach file in email. We are getting error message "download failed path doesn't…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)