Excel Management

Excel 2016 stuck on opening 100% if it contains external links

On our companies computers, all the new laptops come with windows 11 and this problem only occurs on these new computers. When people are trying to open files that have workbook links it will just get stuck opening the file at 100% and nothing will…

Modifications are not saved, excel file not generated. Unable to save and generate upload file in Excel on Mac OS

I need to generate an upload file from a Microsoft Excel sheet with Macros. However, I keep getting the statement, 'Modifications are not saved, excel file not generated. Unable to save and generate upload file' in Excel on Mac Book. Any help will be…

ActiveX Issue in Excel version 2502

When using the above ActiveX forms on Excel version 2502, Build 16.0.18526.20044 with the below VBA code, it gives a 429 error (ActiveX component can't create object), but it works without issue on version 2412 Build 16.0.18324.20240. Private Sub…

MSoffice 2019 - Microsoft Excel is not working.

We have purchased MS office 2019 Professional through one of our supplier. This was purchased for one the control system project of ours supplied to IOCL. for mapping the purchased MS Office to a email ID, one email ID was created…

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…

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

"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 ?

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…

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,277 questions

Sign in to follow

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,763 questions

Sign in to follow

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…

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,…

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,231 questions

Sign in to follow

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,291 questions

Sign in to follow

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,763 questions

Sign in to follow

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 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

Sign in to follow

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,291 questions

Sign in to follow

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,763 questions

Sign in to follow

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,277 questions

Sign in to follow

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,763 questions

Sign in to follow

Office Visual Basic for Applications

Office Visual Basic for Applications

Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.

1,496 questions

Sign in to follow

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,763 questions

Sign in to follow

Office Visual Basic for Applications

Office Visual Basic for Applications

Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.

1,496 questions

Sign in to follow

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.

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…

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

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)?