1,685 questions with Excel Management tags

Sort by: Updated
1 answer

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.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2024-07-04T21:01:09.3766667+00:00
Nathanael Andrade 0 Reputation points
commented 2024-07-05T14:24:17.0233333+00:00
Nathanael Andrade 0 Reputation points
2 answers

"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 ?

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
443 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2023-10-25T20:03:28.8633333+00:00
zubaid ahmed 0 Reputation points
commented 2024-07-04T11:55:51.04+00:00
gmuir 0 Reputation points
1 answer

how to get the PIVOTBY function working on my excel

how to get the PIVOTBY function working on my excel?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2024-07-03T18:26:18.65+00:00
Jason 0 Reputation points
answered 2024-07-04T01:55:54.84+00:00
Emi Zhang-MSFT 23,351 Reputation points Microsoft Vendor
1 answer

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"…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,821 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,684 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2024-07-01T13:55:40.4033333+00:00
patrick verne 0 Reputation points
answered 2024-07-03T19:29:45.81+00:00
Tulinawe Ismail 0 Reputation points
1 answer

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?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2024-07-02T20:42:34.7166667+00:00
polski86 0 Reputation points
answered 2024-07-03T05:25:01.58+00:00
Jiajing Hua-MFST 7,315 Reputation points Microsoft Vendor
1 answer

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 Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2024-07-01T12:38:35.7833333+00:00
Mohammed Kasim 20 Reputation points
answered 2024-07-03T01:47:15.95+00:00
Jiajing Hua-MFST 7,315 Reputation points Microsoft Vendor
1 answer

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
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2024-07-02T19:50:39.59+00:00
Samantha Huie 0 Reputation points
commented 2024-07-02T22:16:10.0766667+00:00
Barry Schwarz 2,421 Reputation points
0 answers

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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,684 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2024-07-02T01:57:35.15+00:00
Raihana 0 Reputation points
edited the question 2024-07-02T07:45:59.2+00:00
Jiajing Hua-MFST 7,315 Reputation points Microsoft Vendor
2 answers

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'.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2020-11-09T04:22:31.007+00:00
Anonymous
commented 2024-07-02T04:10:56.2166667+00:00
Varun Sharma 0 Reputation points
3 answers

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

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,217 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
Microsoft Teams Development
Microsoft Teams Development
Microsoft Teams: A Microsoft customizable chat-based workspace.Development: The process of researching, productizing, and refining new or existing technologies.
3,010 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2024-06-11T11:04:59.1266667+00:00
Hamxa Khan 0 Reputation points
commented 2024-07-01T05:17:21.9366667+00:00
Jiajing Hua-MFST 7,315 Reputation points Microsoft Vendor
0 answers

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 =…

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,684 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2024-06-29T21:45:20.9966667+00:00
de33ed BS 0 Reputation points
edited the question 2024-07-01T01:18:40.9166667+00:00
Jiajing Hua-MFST 7,315 Reputation points Microsoft Vendor
1 answer

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…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2021-02-02T19:56:05.38+00:00
Hines, Beth 1 Reputation point
commented 2024-06-28T12:05:53.5166667+00:00
KlausG 0 Reputation points
1 answer

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

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2024-06-27T14:01:12.7233333+00:00
Adriana Nistoroiu 0 Reputation points
answered 2024-06-28T01:53:31.27+00:00
Jiajing Hua-MFST 7,315 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

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? …

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2024-06-27T03:47:27.2866667+00:00
Jose A 20 Reputation points
accepted 2024-06-27T07:30:36.72+00:00
Jose A 20 Reputation points
1 answer

I dont see automatization card in excel

private pc

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2024-06-06T10:41:18.78+00:00
Kateřina Baťková 0 Reputation points
commented 2024-06-27T06:59:50.8966667+00:00
Jiajing Hua-MFST 7,315 Reputation points Microsoft Vendor
1 answer

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…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2024-06-17T06:05:40.3166667+00:00
David Polsangi 0 Reputation points
commented 2024-06-27T06:39:54.5933333+00:00
Jiajing Hua-MFST 7,315 Reputation points Microsoft Vendor
1 answer

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…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,436 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2024-06-26T16:37:09.0333333+00:00
IniobongNkanga-8038 296 Reputation points
commented 2024-06-27T05:40:37.08+00:00
Emi Zhang-MSFT 23,351 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

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…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2024-06-24T18:16:05.14+00:00
Rosie, Nina 20 Reputation points
commented 2024-06-25T18:47:18.1666667+00:00
Rosie, Nina 20 Reputation points
1 answer

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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2024-06-24T20:16:23.56+00:00
MOIZ ARSHAD 40 Reputation points
answered 2024-06-25T02:38:00.76+00:00
Jiajing Hua-MFST 7,315 Reputation points Microsoft Vendor
1 answer

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.

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,684 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2024-06-23T15:33:46.4+00:00
Alden Kollman 0 Reputation points
answered 2024-06-24T07:13:14.9166667+00:00
Jiajing Hua-MFST 7,315 Reputation points Microsoft Vendor