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 - 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
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…
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
Share Excel File to Power Macros Spreadsheet
Hey all, I hope someone already has done something similar as I am hitting a wall. In the team we have a spreadsheet on local network where we list part with some parameters; The data is used to run Macros to produce pdf drawings i.e. combine image with…