1,717 questions with Excel Management tags

Sort by: Updated
1 answer

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…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,663 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,919 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,936 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,717 questions
asked 2024-07-18T20:49:58.24+00:00
Tashpulatov, Azizbek 0 Reputation points
answered 2024-10-19T14:02:48.6766667+00:00
Viswjheet Viswjheet 0 Reputation points
3 answers One of the answers was accepted by the question author.

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…

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,717 questions
asked 2023-05-25T14:58:38.27+00:00
Ahmed Moursi 20 Reputation points
commented 2024-10-19T13:56:19.35+00:00
Viswjheet Viswjheet 0 Reputation points
1 answer

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…

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,717 questions
asked 2024-10-15T15:52:58.36+00:00
Patrick POULY 0 Reputation points
answered 2024-10-16T02:30:34.79+00:00
Emi Zhang-MSFT 25,156 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,919 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,717 questions
asked 2024-10-12T11:13:56.5233333+00:00
Elvis Necovski 20 Reputation points
accepted 2024-10-15T01:17:22.7666667+00:00
Elvis Necovski 20 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,993 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,919 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,295 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,717 questions
asked 2024-06-11T11:04:59.1266667+00:00
Hamxa Khan 0 Reputation points
commented 2024-10-11T11:04:27.5733333+00:00
Koteswara Sharma 0 Reputation points
0 answers

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…

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,740 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,936 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,717 questions
asked 2024-10-04T08:18:04.68+00:00
Ged 0 Reputation points
edited the question 2024-10-07T06:58:10.1933333+00:00
Emi Zhang-MSFT 25,156 Reputation points Microsoft Vendor
1 answer

How to fix Mdxscript(model) (6,68) calculation error in measure 'Sheetname': Function 'Dateadd' only works with contiguous data selections:

Hi team, I have encountered the below error message when refreshing the data. The query did not run or the Data Model could not be accessed. Here's the error message we got: Mdxscript(model) (6,68) calculation error in measure 'Sheet name': Function…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,919 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,717 questions
asked 2024-09-30T09:19:31.85+00:00
JUNHEE CHO 0 Reputation points
commented 2024-10-06T12:52:01.91+00:00
JUNHEE CHO 0 Reputation points
1 answer

Excel 365 when closing a window appears, The error '1004' has occurred at runtime:

Excel 365 when closing a window appears, The error '1004' has occurred at runtime: Error defined by the application or the object. I already reinstalled the office and it remains the same, any ideas????

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,936 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,717 questions
asked 2021-09-18T17:14:26.033+00:00
Olpega 3 1 Reputation point
commented 2024-10-03T13:24:49.9933333+00:00
Iñigo 6 Reputation points
1 answer

Excel: Setting up Conditional Formatting for Skill Expiry Dates

Hello, How can I set up conditional formatting for expiration dates in Excel? I have a sheet with names in a column, skills across the top, and dates in the cells specifying when these skills were completed. There are four types of skills that expire…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,919 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,717 questions
asked 2023-10-26T02:17:21.92+00:00
Net973 10 Reputation points
commented 2024-10-02T19:04:45.52+00:00
Barry Schwarz 2,981 Reputation points
0 answers

Excel Automate Changing Formula on Corresponding Tabs.

I am trying to use the Automate feature to simplify some data structuring for my team. Once properly arranged said data is dispersed across two tabs in the same file using a Filtering formula. Once I engage the Automate function the formula on the…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,919 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,936 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,717 questions
asked 2024-10-01T12:32:23.99+00:00
Elia, Nicholas (HEALTH) 20 Reputation points
edited the question 2024-10-02T00:59:47.5666667+00:00
Emi Zhang-MSFT 25,156 Reputation points Microsoft Vendor
1 answer

Excel copy and paste issues

Excel copying problem: For example, if a cell is entered with a value of 1 and two blank cells are selected with the mouse, the content cannot be pasted and only one image with a value of 1 can be pasted. But copying this cell to a blank cell can paste…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,663 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,717 questions
asked 2024-09-26T05:42:37.4333333+00:00
佳琪 闫 0 Reputation points
answered 2024-09-30T09:37:52.3966667+00:00
Jiajing Hua-MFST 10,155 Reputation points Microsoft Vendor
1 answer

Excel is showing below error.Also, Microsoft Office365 Marketing email keeps on popping up on right side.

Screenshot 2024-09-26 182800.png

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,919 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,717 questions
asked 2024-09-26T13:00:14.7866667+00:00
vidhi jaiswal 0 Reputation points
answered 2024-09-27T06:25:02.04+00:00
Emi Zhang-MSFT 25,156 Reputation points Microsoft Vendor
1 answer

Autofilter and Sort functions on Protected shared Excel file breaking down periodically with user's input

Hi all. We are having quite an issue in our company: I did set up an Excel file with macros enabled that allowed, out of 62 columns and 402 rows; to basically input data in multiple ways across the columns (dropdowns, text, date...); as well as having…

OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
1,128 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,717 questions
asked 2024-09-23T18:26:00.09+00:00
Adria Termes 0 Reputation points
commented 2024-09-24T10:15:39.01+00:00
Adria Termes 0 Reputation points
2 answers

Export from SQL server to Excel with rich-text staying in each cell

Need to export from SQL server database to Excel. Data type is ntext and contains rich text. I need the data from each record to maintain within one Excel cell and preserve the rich text, i.e. line breaks and formatting.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,579 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,717 questions
asked 2024-09-23T16:45:19.29+00:00
Richard Bonnette 0 Reputation points
commented 2024-09-24T02:19:03.6033333+00:00
ZoeHui-MSFT 36,666 Reputation points
3 answers

How do I use a function on a table column in Query, when I want the inputted report to translate into a different number in Excel? Update: I need syntax help

I know my title is confusing, it's the best I could do. I am inputting an Excel report into Query, to organize it and lay it out on a spreadsheet. One of my values I want to show up as a duration, based on the date that came in on the report. For…

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,993 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,919 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,717 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,552 questions
asked 2024-08-20T21:05:09.7233333+00:00
Marissa Austin 0 Reputation points
edited the question 2024-09-20T07:49:17.47+00:00
Rakesh Gurram 8,585 Reputation points Microsoft Vendor
2 answers

PivotTable in Excel

Hi All, I'm using a tabular model in Excel, everytime i add a filter, row or column in the PivotTable, the excel tries to execute the query to refresh data. Since our tabular model is full of data and dax, it takes time every time the excel refresh…

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,285 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,717 questions
asked 2021-05-03T21:26:19.957+00:00
Samir abdelmalek 21 Reputation points
edited a comment 2024-09-19T02:30:33.8966667+00:00
MyName-0111 0 Reputation points
1 answer One of the answers was accepted by the question author.

The 0 and null in the condition of the IF function

If A1=0, then B1 displays' No ', If A1 is null, then B1 displays "/", Otherwise, B1 will display 'Other'

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,717 questions
asked 2024-09-16T14:09:45.9833333+00:00
01 wyeu 120 Reputation points
accepted 2024-09-17T14:38:50.0633333+00:00
01 wyeu 120 Reputation points
2 answers One of the answers was accepted by the question author.

Unable to permanently grey out macro settings in Office 365 Apps for Business

Hi, I am trying to lock down macros, primarily in Excel. Clients have Business Premium, Windows 11 Business and Microsoft 365 Apps for Business, managed by Intune. I also have a Windows 2019 1809 RDS server for testing which has Microsoft 365 Apps for…

Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,155 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,717 questions
Microsoft Intune
Microsoft Intune
A Microsoft cloud-based management solution that offers mobile device management, mobile application management, and PC management capabilities.
5,110 questions
asked 2024-09-16T06:58:30.02+00:00
Simon Burbery 681 Reputation points
commented 2024-09-17T01:52:30.5066667+00:00
Simon Burbery 681 Reputation points
1 answer One of the answers was accepted by the question author.

COMMENT CREER PLUSIEURS LISTES DEROULANTES DANS UNE CELLULE, EN FONCTION DE LA REPONSE QUI APPARAÎT DANS LA CELLULE DE GAUCHE

Bonjour, Je souhaiterai créer un fichier excel avec la possibilité de faire apparaître plusieurs liste déroulante dans une cellule, en fonction de la réponse qui est choisie dans la cellule de la colonne précédente. Exemple : J'ai réussi à le faire pour…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,919 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,717 questions
asked 2024-09-13T07:32:15.6166667+00:00
Maryse NGINAMAU 20 Reputation points
commented 2024-09-16T08:06:58.7566667+00:00
Maryse NGINAMAU 20 Reputation points
1 answer One of the answers was accepted by the question author.

Migrate VBA to vb6, vb.net, or c++

I have VBA code heavily integrated with Excel and it also creates shapes that will be put into a Powerpoint slide. I want to be able to create an exe file for distribution. What language is best to convert to VB.Net, VB6, C++ ?

C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,742 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,729 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,717 questions
asked 2022-12-28T15:59:31.777+00:00
SouthBound 21 Reputation points
commented 2024-09-12T10:39:28.32+00:00
twinBASIC programming 0 Reputation points