Excel - how to convert dd-mmm-yyyy to dd/mm/yyyy
My date format is now 01-Oct-2024, how can i use excel formula to change to 01/10/2024 dd/mm/2024
Pivot Table doesn't count all data
Everything in the table is mostly correct except the ones with the correct numbers on the right. I kept refreshing the data, but it's still not giving me the correct data and I don't know why. For the count, it's counting every…
Otra cuenta de tu organización ya inició sesión en este dispositivo. Intentalo de nuevo con otra cuenta.
mi office no me deja ingresar Correlation Id: 76bf7b82-af8c-5640-bd8c-c46d8a8d3b01 Timestamp: 2023-05-08T13:02:52.000Z DPTI: 0eb6fbfed0064a71e4f84f24bf3e853acbd48b6bed4f2bcdab4f7aef376e507e
Doesn't show the AutoSave button
Hi........! Please answer me, My MS Excel doesn't show the AutoSave icon/ (on and off button) on the top of the left-hand corner. why so that? please give me a solution. My other MS Office products (MS Word, Powerpoint, etc.... are shown it). please sort…
How to calculate the date difference excluding weekend and public holidays for specific date format
I have the following date format , but I can't use these date format to calculate the date difference excluding weekends and holiday. The two date is input as 01-Oct-2024 and 15-Oct-2024. The result should be 9. However, when I use excel function…
Excel's default workbook calculation keeps changing to manual
Got myself a new laptop, after installing Office 365, my Excel's default workbook calculation keeps changing to manual, even though I did not open a file which had manual calculations saved before. Even after I change the settings to be automatic…
Formula problem Excel
Can you please help me? I have a table where columns A and B are combinations of 12 to 19 numbers, and I need to obtain the common number between columns A and B. Any help is appreciated.
Delete multiple members of distribution group using CSV thru Exchange Management Shell On Premise
I received a request from our employees to delete all the members of this particular distribution group within our organization, and upon checking this DL has a total of 7,000 members. Is there any powershell script I can use to delete just the members…
Too much data in PowerQuery can cause Excel to freeze
Import data from an Excel workbook through Power Query, but the data is quite large, with approximately 3000+rows. Importing is normal, but when loaded into Excel, it can cause Excel to freeze. I have created a simple example and this issue will not…
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 can't a program I am writing a script in (AutoHotKey) not getting access to Excel's COMObject feature?
I've been on a chat for hours with Microsoft support and they have passed me on to you here. I have been working with chatGPT, trying to write a script to enable Excel to use a few Auto Hot Keys to run a simple stopwatch function directly in a sheet? …
creating ODBC connection for Microsoft Excel Driver 64 bit
I have ran ODBC 64-bit as administrator. I have added a new connection with the SystemDSN tab. I then click on Microsoft Excel Driver. In the Dialog I enter the datasource name, description and click on select Workbook and choose my Office 365 Excel 64…
Excel convert date format
My date format is now 01-Oct-2024, how can i use excel formula to change to 01/10/2024 dd/mm/2024
not able to access the macro.
Hi, I'm not able to access macro, could you please help me on this!
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…
Excel Stocks Data Type Error - Subscription Sign-in Required
I have been using the stocks data types feature on Excel without any issues until yesterday. However, I'm now receiving the following error message: "You need to sign in with an account associated with a subscription to use these data types. Select…
Table transform in Excel
Hello, I have raw data that are extracted in complex design, so I need to transfer these data from below: to below design: There are thousands of Customers IDs and thousands of Parts and Parts type, each part has 2 subtypes, so subtypes need to be…
macros et classeur partagé
Bonjour, j'ai un classeur tout simple : une feuille liste de personnes avec une colonne pour le nom et une autre pour le numéro d'adhérent. La feuille est protégée pour éviter les erreurs de manipulation. Ce classeur doit être partagé sur un réseau…
How to setup custom expiry dates for tasks with visual reminders
Hi, I am creating a custom show management tool using MS Excel. I need help with setting up expiry dates. The expiry dates will work backwards from the show start date (B3) and change colour. Colour changes will include no change when still ok, orange…