Microsoft Q&A

Excel Management

1,414 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,414 questions with Excel Management tags

Sort by: Updated
Updated Created Answers
1 answer

Excel problemas con contraseñas de rangos no reconocidas

Buenas tardes, reciban un cordial saludo. Tengo un problema con un archivo de excel 2013 compartido, con rangos bloqueados a usuarios. Este archivo tiene 2 hojas, en las cuales en cada una tengo 3 tipos de rangos y cada uno tiene contraseña. Cada rango…

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
7,518 questions
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
435 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
4,746 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
544 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,414 questions
asked 2023-06-06T01:10:43.25+00:00
Juan Carlos Barrios Medina 0 Reputation points
answered 2023-06-06T10:30:55.39+00:00
Limitless Technology 26,656 Reputation points
1 answer

Unable to open Excel desktop application from Chrome and Edge

Hello! We have a user in our Office 365 enviornment which has been struggling to open Excel documents in Chrome and Edge, however it still works in Internet Explorer. The following solutions have been tried: Resetting Chrome settings &…

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
7,109 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,414 questions
asked 2021-11-18T13:24:05.12+00:00
Alexander Syring 1 Reputation point
commented 2023-06-06T07:17:30.19+00:00
Tanay Prasad 325 Reputation points
3 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.
544 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,414 questions
asked 2023-06-02T14:09:29.55+00:00
dtaraboletti 0 Reputation points
commented 2023-06-06T00:49:15.7366667+00:00
Emi Zhang-MSFT 13,081 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,192 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
544 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,414 questions
asked 2023-05-31T18:51:59.58+00:00
Ronit 0 Reputation points
commented 2023-06-05T13:09:06.4133333+00:00
SadiqhAhmed-MSFT 27,501 Reputation points Microsoft Employee
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,445 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,414 questions
asked 2022-09-26T22:10:32.693+00:00
Said A 591 Reputation points
commented 2023-06-05T11:27:06.35+00:00
Asif Ali Haider 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,414 questions
asked 2023-06-02T18:53:30.2966667+00:00
Delia Rojas 0 Reputation points
commented 2023-06-05T08:30:12.15+00:00
Emi Zhang-MSFT 13,081 Reputation points Microsoft Vendor
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,414 questions
asked 2020-07-27T18:53:59.793+00:00
Asha Kanta Sharma 11 Reputation points
commented 2023-06-04T08:00:10.5+00:00
LiarteSepena, Julio 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,414 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…

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,691 questions
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,898 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,414 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
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.
798 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,414 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…

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,333 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
544 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,414 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,414 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,771 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,079 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
544 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,414 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,414 questions
asked 2021-01-27T15:58:09.997+00:00
Harold Dolman 26 Reputation points
answered 2023-05-31T17:42:16.14+00:00
اسماء امين عبده ابوزيد 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…

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,445 questions
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.
798 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,034 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,414 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,871 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,414 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,807 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
544 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,510 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,414 questions
asked 2023-05-19T20:07:39.09+00:00
Tevon2.0 951 Reputation points
commented 2023-05-30T08:40:02.6033333+00:00
Emily Du-MSFT 29,441 Reputation points Microsoft Vendor
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.
544 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,414 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,771 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.
544 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,414 questions
asked 2023-05-25T23:45:30.18+00:00
Barry Schwarz 816 Reputation points
accepted 2023-05-27T07:10:27.0133333+00:00
Barry Schwarz 816 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,414 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