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"…
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)
How do I write an excel formula to count the number of times a result occurs in a column for each user (user name in another column of same data set)?
Data Sources: Summary data table which contains a column for employee name and a column for each type of occurrences we want to track, e.g. wrong status or past due date Detail data is on another tab and contains a column with employee name as well as…
Unable to correctly print all tabs/files from Excel that was shared document
I have a user who has access to a shared SharePoint site and user downloaded an excel file on his pc locally. User then attempts to copy and paste 4 certain tabs from the excel file to a new excel file removing any hyperlinks and any attachments. The…
How to embed a video in an Excel Userform?
I want to be able to insert a video into a frame in an excel user form.
Microsoft Onedrive for Business
I am experiencing an issue with a Microsoft Excel file stored on SharePoint. When I open this file, the AutoSave feature automatically saves it to my local OneDrive account instead of the shared SharePoint drive. This is causing confusion and…
Excel 1900 leap year bug
I think that Excel's 1900-02-29 bug should be fixed. Over the years, many other users have complained about this. To prevent any disruption, "Thu, 1900-03-01" should retain its "day 61" serial number, so that all later dates…
Excel, percentages in conditional formatting
I have multiple columns with complex conditional format data in excel. For example, if people attend a recent course they go green, if training is out of date they turn red. I want to be able to create a constant updating percentage of the number who…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
In excel, it is very hard to find the mouse stays in that cell, how to solve it?
In excel, the cell where the mouse is located will be identified with a thin black box, please, is there any way to modify the color and line thickness of this thin black box, so that the user can easily identify the mouse to stay in that cell? Thank…
Errors were detected while saving excel file how I should save it
Errors were detected while saving excel sheet how I should save it.
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
Datestamps in Excel when a cell value changes
I've already looked up adding datestamps in Excel. Not a problem. I already have a table with data in it. I don't want to display the current date if there is already data in the cell. I only want the datestamp to update when the other cell value…
My admin-managed Excel Office.js add-in is not appearing on iPad
Hi there, I've developed an Office.js excel add-in which has recently been deployed by my organisation through Integrated Apps. The add-in works perfectly on MacOS and through the browser, but I would like to use it on iPad. The 'admin-managed' add-in…
How to add Analyze data if already add
Hello, I already add-ins Analysis ToolPak and Analysis ToolPak - VBA but The Analysis Data tool does not appear on my Home. My Excel is Version 2405. How & What should I do? Please Help Me !!!
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)