1,685 questions with Excel Management tags

Sort by: Updated
Updated Created Answers
1 answer One of the answers was accepted by the question author.

How to enable office intelligent services in microsoft office 2019 pro plus?

I have tried file --> options --> general to enable this feature but it was missing in the list. LICENSE NAME: Office 19, Office19ProPlus2019MSDNR_Retail edition LICENSE DESCRIPTION: Office 19, RETAIL channel My Office version is …

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,058 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 2020-10-07T07:49:01.903+00:00
Shubham Verma 21 Reputation points
accepted 2020-10-07T08:33:43.27+00:00
Shubham Verma 21 Reputation points
4 answers

remote desktop session Excel to local machine excel copy paste issue

Hi, We have recently upgraded our remote desktop servers to windows server 2019 Datacenter. This issue with excel started around two weeks after that so not sure if it is related to that. Our users access the application on their local machine which is…

Remote Desktop
Remote Desktop
A Microsoft app that connects remotely to computers and to virtual apps and desktops.
4,368 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 2020-09-04T10:33:23.887+00:00
Abhi 1 Reputation point
commented 2020-10-06T11:08:11.973+00:00
Abhi-6410 1 Reputation point
1 answer One of the answers was accepted by the question author.

How to show only one series and data in xlColumnStacked chart in Microsoft.Office.Interop.PowerPoint?

xlColumnStacked always shows 3 columns.

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,058 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 2020-10-02T13:52:21.83+00:00
Riddhi Pansuria 21 Reputation points
accepted 2020-10-05T05:08:52.797+00:00
Riddhi Pansuria 21 Reputation points
3 answers

How to translate Excel Functions to Power Query M for IF and XLOOKUP functions?

Hi, I am new to Power Query Editor (is this abbreviated PQE?) and have been using it to automate the process of editing data from a *.csv. I have been trying to add a custom column to PQE. However, in my naivety, I was unaware that Excel functions are…

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-09-30T09:20:04.867+00:00
Joel Taylor 71 Reputation points
answered 2020-10-05T04:46:01.11+00:00
Joel Taylor 71 Reputation points
3 answers

Locked EXCEL document

I have a excel spread sheet that is password protected and can't open it, i have put a lot of info and work into it :-( . any ideas or programs that can unlock it. any assistance will be muchly appreciated

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-08-18T04:42:55.227+00:00
shaun priday 1 Reputation point
commented 2020-10-03T21:14:06.883+00:00
Raymond Roe 1 Reputation point
3 answers

What is the best way to create data visualizations for sharepoint online list?

I am tasked with creating some data visualizations that pulls its live data from a SharePoint online list. The only way I can think to do it is to export the list data and save the file in the same SharePoint site in a library, making a connection…

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,153 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 2020-09-09T22:50:05.423+00:00
Angela French 11 Reputation points
answered 2020-10-02T16:21:21.207+00:00
Angela French (ctcLink) 1 Reputation point
1 answer One of the answers was accepted by the question author.

Other Users using the Mini Calander and Date Picker

I downloaded the Mini Calendar and Date Picker for Excel by Vertex42. If I send an Excel worksheet to another person and I want them to insert From and To dates in one or multiple cells, does that user required to download the calendar as well? …

Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
894 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 2020-09-23T22:20:16.53+00:00
Wen 21 Reputation points
commented 2020-10-02T13:12:38.03+00:00
Wen 21 Reputation points
5 answers

How to force user to open files only from one location on Office 2016

Hello, We have an Excel 2016 published on Citrix for our users. We have a requirement that user can open spreadsheets from one specific location (user homedrive mapped in his AD profile). We have blocked navigation via Windows Explorer and via address…

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,058 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
Windows Server Security
Windows Server Security
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Security: The precautions taken to guard against crime, attack, sabotage, espionage, or another threat.
1,774 questions
asked 2020-09-21T07:38:23.8+00:00
Michal Zyzak 31 Reputation points
commented 2020-10-01T09:05:14.83+00:00
Emily Hua-MSFT 27,581 Reputation points
4 answers

Problem with office theme colors (Office 2019 VLC on premise)

Dear All, I just installed from scratch brand new computers with Windows 10 Enterprise and Office 2019 Pro Plus VLC. I noticed that it's not possible to save the selection of office theme (Outlook, Word, Excel etc..) With our old computers…

Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
907 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 2020-09-23T17:22:18.22+00:00
William 361 Reputation points
commented 2020-10-01T02:19:58.893+00:00
Emily Hua-MSFT 27,581 Reputation points
2 answers

Keep rolling total of two columns being subtracted

Good Morning, I need some help on an excel formula that subtract the time(c column) a persons state(H Column) goes from Logon to Avail or logoff and tallys that for the full column. Goal is to have a rolling total count how long a person takes…

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,058 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 2020-09-22T15:49:06.73+00:00
Jesse 1 Reputation point
commented 2020-09-30T09:43:04.103+00:00
Emi Zhang-MSFT 23,351 Reputation points Microsoft Vendor
3 answers One of the answers was accepted by the question author.

Excel , Data numen

Hi, I downloaded the online shopping cart , from Data numen I’d like to add a column in the “inventory” as “stock” this will have all our stock quantities in, can we get it so when our customers add item/s to their cart it deducts from the…

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-09-29T09:16:00.957+00:00
rob bowers 21 Reputation points
commented 2020-09-30T09:39:26.86+00:00
Emi Zhang-MSFT 23,351 Reputation points Microsoft Vendor
0 answers

Is it possible to manage a group of learners within an organisation?

Is it possible to manage learners from the same organisation to suggest courses and manage progress? As a manager of a small team of 3 I would like to suggest (not limit) courses that would be useful and be able to centrally see how they are…

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-09-22T20:44:16.457+00:00
Colin Morris 1 Reputation point
commented 2020-09-30T09:29:46.033+00:00
Emily Hua-MSFT 27,581 Reputation points
1 answer

Excel 2013 Pivot Table category is not correct.

Excel 2013 pivot table shows a different name for a category than what is in the data table (data source it pulls from). i.e. "miscellaneous" shows as "win". There is no category "win" in the data source table. I've tried…

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-09-29T20:12:58.653+00:00
TDW 1 Reputation point
answered 2020-09-30T09:17:26.507+00:00
Emi Zhang-MSFT 23,351 Reputation points Microsoft Vendor
1 answer

Save changes to the same document

In the company we have documents in folders on the server which some are shared and others are not, those that are not shared, not having anyone else editing the file should let me save the changes in the same document, but now when I make changes in A…

Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
907 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 2020-08-07T22:40:48.36+00:00
Michelle Garcia 1 Reputation point
commented 2020-09-24T16:19:48.137+00:00
Michelle Garcia 1 Reputation point
2 answers One of the answers was accepted by the question author.

Can I make a dot net dll in visual studio (using visual basic) and have Excel call its methods?

I would like to create a dll using visual basic dot net, and then call its methods/functions from Excel's VBA. That way, Excel can pass data to my dll, and obtain a vector of answers. Can this be done?

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,823 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 2020-09-14T17:51:43.29+00:00
Gideon Maven 21 Reputation points
accepted 2020-09-19T20:40:38.117+00:00
Gideon Maven 21 Reputation points
1 answer One of the answers was accepted by the question author.

big VBA macro-execution suddenly slow

i've made a little "software" using excel + VBA so i can automate and speed up the process to plan our factory production. well, out of nowhere the macro execution is super slow on win10/excel 2016, but still perform really well on old…

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-09-18T07:45:36.043+00:00
tommaso bertocchi 21 Reputation points
commented 2020-09-18T08:00:11.043+00:00
tommaso bertocchi 21 Reputation points
3 answers

Connect Excel DB to MS Sql Server

I just installed MS SQL Server Management Studio and I need help connecting to an Excel database.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,208 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 2020-09-10T15:44:08.97+00:00
Mansi Mehan 1 Reputation point
answered 2020-09-16T12:22:05.447+00:00
Yitzhak Khabinsky 25,721 Reputation points
1 answer

Inquiry about making prediction sheet among functions of Excel

Hello. Among the functions of Excel, I would like to know the formula or formula to obtain the smoothing coefficient (alpha, beta, gamma) value for FORECAST.ETS () function, which is a function used in making prediction sheets.

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-09-10T03:07:08.49+00:00
박우호 1 Reputation point
commented 2020-09-16T09:57:13.197+00:00
Emi Zhang-MSFT 23,351 Reputation points Microsoft Vendor
1 answer

Where is the Datamodel stored?

Good afternoon, I have some questions about the Datamodel in Excel. Where is the Datamodel stored on your Laptop? Or is the Model attached to the file? If I make a copy or move the file somewhere in the cloud, does it still work? I created a…

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-09-12T14:12:28.817+00:00
Bogert Marco 1 Reputation point
commented 2020-09-16T09:55:48.417+00:00
Emi Zhang-MSFT 23,351 Reputation points Microsoft Vendor
1 answer

Excel Automation Addin is inactive state

Excel Automation Addin is inactive state when I turn on "Requires Application Addins to be signed by Trusted Publisher"

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-09-14T14:18:55.723+00:00
sateesh kumar gompa 1 Reputation point
commented 2020-09-16T09:55:15.493+00:00
Emi Zhang-MSFT 23,351 Reputation points Microsoft Vendor