1,759 questions with Excel Management tags

Sort by: Updated
1 answer

Excel Macros Not Running on Company Server

Hello, I have an issue where Excel macros work fine on my PC, but when the file is stored on my company’s server, macros are blocked. Excel shows a security risk warning in pink, and the "Unblock" checkbox is missing from the file…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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,759 questions
asked 2025-02-17T13:31:03.38+00:00
EULOGIO JIMENEZ JIMENEZ 0 Reputation points
answered 2025-02-18T00:56:11.28+00:00
Emi Zhang-MSFT 27,871 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Power Query error 0xC0000005

User reported experiencing an error (0xC0000005) when running Power Query on two different queries in Excel LDAP settings have been verified correct

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,759 questions
asked 2025-02-15T06:22:24.7933333+00:00
Simpson, Alan 20 Reputation points
accepted 2025-02-17T03:29:30.3166667+00:00
Simpson, Alan 20 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.
474 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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,313 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,759 questions
asked 2023-10-25T20:03:28.8633333+00:00
zubaid ahmed 5 Reputation points
commented 2025-02-14T15:11:44.54+00:00
Richard Price 0 Reputation points
1 answer

how to stop refresh removing field entries.

When I enter or update a comment in the comment field and perform a refresh the comments that I entered are removed. How I write entries in the comment field. I create a query called comments and enter the comments in the output and then create another…

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,759 questions
asked 2025-02-12T18:22:31.2033333+00:00
Norman McIlwaine 0 Reputation points
answered 2025-02-13T06:00:14.9366667+00:00
Emi Zhang-MSFT 27,871 Reputation points Microsoft Vendor
1 answer

Transferring macros from older Excel to new Excel running under Windows 11

I created custom number formats in Excel on my Windows 10 machine. (kg, fm, m3, etc......) I placed these with small icons on the ribbon. I bought a new machine running Windows 11. I was able to import the ribbon items into Excel on the new machine.…

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.
4,274 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,759 questions
asked 2025-02-08T09:26:52.0066667+00:00
Péter Szabó 0 Reputation points
edited the question 2025-02-10T02:24:09.3466667+00:00
Emi Zhang-MSFT 27,871 Reputation points Microsoft Vendor
1 answer

Files on SharePoint cannot be edited due to the error that shows we temporarily repaired.

Hello Please i need your help on this issue. There is an error message saying WORK BOOK REPAIRED We temporarily repaired this workbook so that you can open it in Reading View on a SharePoint file. The user is trying to Edit Workbook ] Fix it ] Ran…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,227 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,759 questions
asked 2025-01-25T00:57:29.9366667+00:00
IniobongNkanga-8038 936 Reputation points
edited the question 2025-02-06T07:57:01.8433333+00:00
AllenXu-MSFT 23,741 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Using IFerror with Left formula to separate numbers from text

I have an excel spreadsheet connected to an MS form and the MS form has options to choose for each question which pulls through into an excel table for example: - 1 - Doesn't understand Excel Each answer always starts with either 1, 2, 3, 4 or Absent,…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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,759 questions
asked 2025-02-05T10:01:12.54+00:00
Emma Leigh 20 Reputation points
commented 2025-02-06T01:00:33.6066667+00:00
Jiajing Hua-MFST 14,805 Reputation points Microsoft Vendor
2 answers

Cannot generate embed view for excel workbook to allow guest access

Hi Team, The project I'm working on requires to display an embed view of our excel workbook on one of our web pages so that when a visitor lands on the site, they can use the excel sheet to do some basic budget calculating. In the excel workbook we…

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,227 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.
2,283 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,759 questions
asked 2021-11-18T07:57:03.427+00:00
Charles Huang 31 Reputation points
commented 2025-02-05T17:00:03.3633333+00:00
wade-pro 10 Reputation points
3 answers

I would like to extract a number from a sentence in excel to a separate column using a formula

I have an excel spreadsheet connected to an MS form and the MS form has options to choose for each question which pulls through into an excel table for example: - 1 - Doesn't understand Excel Each answer always starts with either 1, 2, 3 or 4 followed…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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,759 questions
asked 2025-02-05T08:52:48.28+00:00
Emma Leigh 20 Reputation points
answered 2025-02-05T12:41:31.9833333+00:00
riny 260 Reputation points
1 answer

Excel File Flagged as Malicious by Defender MDE

A macros-enabled Excel file is being flagged as malicious by Defender MDE every time changes are made and the file is saved under a different name, resulting in file corruption. Since the SHA value changes with each modification, submitting the file to…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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.
2,283 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,759 questions
asked 2025-02-04T14:28:37.3266667+00:00
Aishwarya RM 20 Reputation points
answered 2025-02-05T05:26:23.53+00:00
Jiajing Hua-MFST 14,805 Reputation points Microsoft Vendor
1 answer

Please help on Pivot Table Refresh online

Hello, I'm having issue with refreshing pivot tables using Excel Online. The pivot tables are built using data model with data source from the tables in existing workbook. When I refresh manually using "Refresh Selected Connection"…

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.
4,274 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,759 questions
asked 2022-07-29T16:58:13.097+00:00
PBIX MM 1 Reputation point
commented 2025-01-31T21:18:21.2933333+00:00
Michelle Ran 346 Reputation points Microsoft Employee
3 answers

Datestamps in Excel when a cell value changes

I've already looked up adding datestamps in Excel. Not a problem. I already have a table with data in it. I don't want to display the current date if there is already data in the cell. I only want the datestamp to update when the other cell value…

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,759 questions
asked 2022-12-20T17:21:58.08+00:00
Daniel Checkman 16 Reputation points
edited a comment 2025-01-28T22:42:56.62+00:00
Paul 25 Reputation points
2 answers

I cannot re-open an xcel file

My xcel file won't reopen. I used Hide for 3 columns then closed the file. Now I can't re-open the file.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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,759 questions
asked 2025-01-21T03:28:09.48+00:00
John Scott 0 Reputation points
answered 2025-01-28T10:12:52.9766667+00:00
Damian 0 Reputation points
1 answer

Unable to find excel content in file explorer search

Environment - Windows Server 2022.                             Office - M365 - as per the MCO. The excel files doesn't show up when the cx tries to search the contents of the excel file in the search bar of the file explorer. The issue only occurs…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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,759 questions
asked 2024-12-24T19:45:50.2333333+00:00
DeepakCONVERGYSCORPORATION-2792 5 Reputation points
commented 2025-01-27T22:38:08.0066667+00:00
John Lewis 0 Reputation points
1 answer

I am trying to update an excel report that someone else created. Anytime I select Data > Refresh All I get the following error: [ODBC Driver Manager] The specified DSN contains an mismatch between the driver and application

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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,759 questions
asked 2025-01-24T21:17:45.4966667+00:00
Cheryl Mallory/USA 0 Reputation points
answered 2025-01-27T07:32:45.4266667+00:00
Emi Zhang-MSFT 27,871 Reputation points Microsoft Vendor
1 answer

Export scheduling poll results to an excel spreadsheet

I am scheduling a meeting using the scheduling poll for over 15 people and over 30 options. Is there a way to export the results to an excel spreadsheet (similar to the Doodle export function)?

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.
5,498 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,759 questions
asked 2023-07-10T17:45:07.75+00:00
Jessica Dery 25 Reputation points
commented 2025-01-24T20:06:01.47+00:00
TenHulzen, Bre 5 Reputation points
1 answer

repair error when opening excel file, all screenshots in the excel file are removed

Hello, When opening an excel file, the following error comes up: "Removed Part: /xl/metadata.xml part with XML error. (Metadata) Catastrophic failure Line 2, column 426. Removed Feature: Worksheet properties from /xl/workbook.xml part…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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,759 questions
asked 2025-01-20T07:48:34.8533333+00:00
MP 0 Reputation points
commented 2025-01-24T08:45:47.0133333+00:00
Jiajing Hua-MFST 14,805 Reputation points Microsoft Vendor
2 answers

Error when importing .csv-file to Outlook calendar

Hi! I want to import a number of calendar events from Excel (.csv) to the Outlook calendar. I created the .csv file myself and made three simple columns to test: Subject (A), Start Date (B), and End Date (C), along with two test rows with values. In…

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.
5,498 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,759 questions
asked 2025-01-08T10:13:30.6633333+00:00
Oskar Ex 0 Reputation points
commented 2025-01-23T08:53:13.95+00:00
Jenne Li-MSFT 1,235 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Can the print settings of EXCEL continue to be used in WORD

When I transfer an EXCEL table to a WORD document, the original EXCEL table that can print two pages only has one page in WORD. If I pull it in WORD, all the content can be displayed, but the header set in EXCEL cannot be displayed. What should I do?

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.
952 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,759 questions
asked 2025-01-21T14:22:13.5566667+00:00
sect Inner 145 Reputation points
accepted 2025-01-22T14:25:21.3966667+00:00
sect Inner 145 Reputation points
1 answer One of the answers was accepted by the question author.

Excel, group, date, part of weekdays.

I have a date and have to write down three to four weekday times every week. The week should be highlighted in colour. How can I achieve this? What is the best way to fill it in? Count up over the day. Autofill. The goal. I'll use formulas now. The…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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,759 questions
asked 2025-01-18T13:30:22.57+00:00
Noah Aas 625 Reputation points
accepted 2025-01-21T15:57:14.9966667+00:00
Noah Aas 625 Reputation points