Microsoft Q&A

Excel Management

1,413 questions

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.

Browse all Office tags

1,413 questions with Excel Management tags

Sort by: Updated
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,413 questions
asked 2023-05-25T14:58:38.27+00:00
Ahmed Moursi 20 Reputation points
answered 2023-06-02T23:11:24.6266667+00:00
Herbert Seidenberg 1,111 Reputation points
1 answer One of the answers was accepted by the question author.

Group values and send email based on excel data.

Hello, I have the following Powershell script and I need a bit of help. The script takes the data from a .csv document and sends email to users that are the owners of each group. [powershell] # Function to create report email function…

Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
4,892 questions
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.
1,685 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,413 questions
asked 2021-06-23T11:39:21.29+00:00
Johan Weber 21 Reputation points
commented 2023-06-02T20:31:01.6966667+00:00
Chris B 0 Reputation points
0 answers

Power Query Question

I appended 31 sheets into a master using power query. Now I need to add the current rate percentage from current month towards their goals which is on a separate sheet. I started doing it manually but I do need it to be dynamic. Help please!

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,413 questions
asked 2023-06-02T18:53:30.2966667+00:00
Delia Rojas 0 Reputation points
0 answers

Pivot Graph Series Color Changes for Previously Set Data Series

I have a Pivot Chart that shows Red/Yellow/Green metrics. I have set the series colors as appropriate for each series. On the occasion that data conditions result in the absence of one of the series...(for instance there are no Red items), this series…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
529 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,413 questions
asked 2023-06-02T14:09:29.55+00:00
dtaraboletti 0 Reputation points
2 answers

Excel Restricted Access Workbook Preventing Autosave

Hi All, We are trying to restrict certain people from editing a file in excel while others can edit. When we use the 'restrict access' for certain individuals it removes the ability for the document to autosave. Is there any workaround for this? We…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
797 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,413 questions
asked 2022-09-15T19:10:18.59+00:00
Angela Ham 11 Reputation points
commented 2023-06-02T10:49:07.3466667+00:00
Hans van Hemmen 0 Reputation points
1 answer

Update method 2016 MSO (16.0.5254.1001) 64-bit

Hello, I used excel version (16.0.4266.1001) 64-bit. I should update the current version as (16.0.5254.1001) - KB5002033. So, I installed KB5002033 then apply this file but it doesn't work. I mean still 16.0.4266.1001 Could you let me know the method of…

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,413 questions
Windows 10 Security
Windows 10 Security
Windows 10: A Microsoft operating system that runs on personal computers and tablets.Security: The precautions taken to guard against crime, attack, sabotage, espionage, or another threat.
2,330 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
529 questions
asked 2023-06-02T05:10:02.8+00:00
SY Choi (최선영) 0 Reputation points
answered 2023-06-02T06:20:38.0866667+00:00
Tanay Prasad 325 Reputation points
1 answer

What qualifier can I use for vbcomponents, other than sheets.add

I am trying to add VBA source code to an EXISTING Excel worksheet. I have an example intended to create a NEW worksheet. Sample: Dim NewSheet as Worksheet Set NewSheet = Sheets.Add ... With…

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,413 questions
asked 2023-05-26T21:43:42.41+00:00
DAVID DURLIN 0 Reputation points
commented 2023-06-01T05:53:45.59+00:00
AllenXu-MSFT 7,611 Reputation points Microsoft Vendor
0 answers

How to get all the billing data for a subscription in Azure on to Excel

I want to get All the billing data for one of my Azure subscriptions, and download that data as a excel file. I know that I can go to "Cost Management + Billing" and download all of cost and billing data, from there. But I cant seem to find…

Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
1,188 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
529 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,413 questions
asked 2023-05-31T18:51:59.58+00:00
Ronit 0 Reputation points
edited the question 2023-06-01T04:29:08.9666667+00:00
Naveenommi 0 Reputation points Microsoft Vendor
2 answers

How to Enable VBA Macros

Hi, Good day! I'm trying to use my VBA Macros applications, but I'm having this error message. Please help me resolve this. It's really a pleasure you would help me with this ASAP. Thank you so much!

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.
1,053 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
529 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,413 questions
asked 2023-05-23T13:09:15.7466667+00:00
Apple E Mananquil 0 Reputation points
edited the question 2023-06-01T01:33:46.1666667+00:00
Jack J Jun 23,661 Reputation points Microsoft Vendor
4 answers One of the answers was accepted by the question author.

What are the possible MODE for Provider=Microsoft.ACE.OLEDB.12.0

What are all the possibilities for MODE for Provider=Microsoft.ACE.OLEDB.12.0 and what do they mean ?

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,413 questions
asked 2021-01-27T15:58:09.997+00:00
Harold Dolman 26 Reputation points
answered 2023-05-31T17:42:16.14+00:00
10 answers

Microsoft should FIX - "Errors were detected while saving (filename)"

Microsoft must FIX this decade long bug with appears out of nowhere and has ruined a lot of months of work of my life. Please fix the below error message. It is even appearing in latest Office 2019. "Errors were detected while saving (filename).…

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,413 questions
asked 2020-07-27T18:53:59.793+00:00
Asha Kanta Sharma 6 Reputation points
commented 2023-05-31T10:56:14.25+00:00
Lachmider, Lukasz J 0 Reputation points
2 answers One of the answers was accepted by the question author.

Embed Images with CDO mail - additional question

Hi, I have seen David JunFeng's solution to embedding inline images at https://social.msdn.microsoft.com/Forums/en-US/f8c701b7-fbef-4a1f-9549-2fd16191dd20/embed-images-with-cdo-mail-in-excel?forum=exceldev The solution is for embedding inline images…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
797 questions
Outlook Management
Outlook Management
Outlook: A family of Microsoft email and calendar products.Management: The act or process of organizing, handling, directing or controlling something.
4,023 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.
2,435 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,413 questions
asked 2023-05-19T13:31:15.34+00:00
Harris Steinman 20 Reputation points
edited the question 2023-05-31T08:14:51.81+00:00
Yuki Sun-MSFT 29,706 Reputation points
6 answers

frequent error when refreshing pivot table

When refreshing a Pivot table that is created from another worksheet, I get: An unexpected error occurred (file'pcminorobjcoll.inl', line 109, function 'PCMinorObjectCollection[class PCProperty.class NameHashSupport]::SetNameAndUpdateCollection') This…

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,413 questions
asked 2021-05-10T19:42:09.177+00:00
Eric Brinsfield 1 Reputation point
answered 2023-05-30T16:58:47.0033333+00:00
Mario González P 0 Reputation points
2 answers

Why won't my SharePoint list export to excel?

Do I need to have some rule turned on for export to excel to work from my SharePoint list?

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
1,797 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,504 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
529 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,413 questions
asked 2023-05-19T20:07:39.09+00:00
Tevon2.0 931 Reputation points
commented 2023-05-30T08:40:02.6033333+00:00
Emily Du-MSFT 29,366 Reputation points Microsoft Vendor
22 answers

Excel "3D Map" feature error: 3D Maps encountered an error while contacting Microsoft Bing mapping services. Functionality may be limited. (Status Code: 4)

Hello, I am running into an issue with Excel application where I am no longer able to use the "3D Map" feature. I used to use the search bar to load the feature but now when i do that i am faced with the following error: 3D Maps…

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.
2,435 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,413 questions
asked 2022-09-26T22:10:32.693+00:00
Said A 591 Reputation points
commented 2023-05-29T10:38:42.2966667+00:00
1 answer

Error message: Contact your admin to enable embed code creation

What is the issue with the prompt "Contact your admin to enable embed code creation" when publishing the WEB on Power BI?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
529 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,413 questions
asked 2023-05-28T14:25:41.9633333+00:00
miu niok 0 Reputation points
edited an answer 2023-05-29T02:00:57.8933333+00:00
AllenXu-MSFT 7,611 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Using a Function macro form another workbook

I have project with multiple workbooks. To simplify macro management, I created a workbook with a single empty worksheet where I store all my macros. When this workbook is open, I can execute any of the Sub macros while working in another active…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
529 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,413 questions
asked 2023-05-25T23:45:30.18+00:00
Barry Schwarz 731 Reputation points
accepted 2023-05-27T07:10:27.0133333+00:00
Barry Schwarz 731 Reputation points
1 answer

Excel Vlookup for SharePoint exported Lists

Hi I have exported a number of SharePoint Lists to an excel spreadsheet, but I can not Vlookup to this data, does anyone know a work around. The files that are exported from SharePoint to excel are Query, so I don't think hold any data. I want to be able…

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,413 questions
asked 2021-02-20T10:54:53.643+00:00
Nathan Blakeley 6 Reputation points
commented 2023-05-24T19:45:03.49+00:00
Averill, Laura E 0 Reputation points
2 answers

Opening excel from teams with macro that are blocked

Hi! I'm opening an Excel file from a teams location. The excel contains macro's that are disabled when opening the excel. How to enable them? in the Trust center the macro's are enabled. But they are not...

Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
6,676 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
529 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,413 questions
asked 2023-05-17T16:06:35.5166667+00:00
Guy Henckaerts 0 Reputation points
commented 2023-05-23T09:03:55.75+00:00
Emily Hua-MSFT 26,921 Reputation points Microsoft Vendor
4 answers

Report a problem with MS Team about unable to open .csv

How are the two versions different. Why can't office 2013 open .csv files?   Open the .csv file on Microsoft Office std 2019 How to fix that?

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
427 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.
2,435 questions
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.
1,685 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
529 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,413 questions
asked 2023-05-15T08:34:29.9633333+00:00
Natjira Yodpunya 0 Reputation points
edited a comment 2023-05-23T06:29:02.3733333+00:00
AllenXu-MSFT 7,611 Reputation points Microsoft Vendor