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

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

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