21,102 questions

Sort by: Updated
0 answers

Excel Removing 0

I have a list of 11-digit NDCs that I need to compare to another list of NDCs ranging from 7 to 11 digits. Excel has removed the leading zeros. I can't simply add them to the front because the zeros might also belong in the middle or at the end of the…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-11-05T16:17:31.0166667+00:00
Karla 0 Reputation points
2 answers

when i am working on Microsoft excel or Microsoft word, it will bring up a dialogue box that says repair and immediately i say repair, it will close the package without letting me save my work

when i am working on Microsoft excel or Microsoft word, it will bring up a dialogue box that says repair and immediately i say repair, it will close the package without letting me save my work

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-11-05T13:56:20.8533333+00:00
ogunleye shola 0 Reputation points
edited an answer 2026-11-05T15:01:34.9833333+00:00
Alina Le 5,805 Reputation points Independent Advisor
2 answers

Auto-resize cell dimensions based on Text Box size

Hi everyone, Is there a way to link a Text Box to a cell in Excel so that the cell (or row/column) automatically expands or shrinks when the Text Box size changes? Alternatively, can a standard Excel cell automatically adjust its height and width…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-11-05T01:47:41.8133333+00:00
Arthur Primee 0 Reputation points
edited an answer 2026-11-05T03:26:28.76+00:00
Jade Ng 16,535 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

How to Fix this Excel Formula?

In the screenshots below you will see the formula I have created as well as the data it corresponds to. The gist of what I am trying to do is have a formula that checks the hire date vs the employees I9 completion date, if the completion date is more…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-11-04T21:27:45.05+00:00
Ryan 0 Reputation points
commented 2026-11-04T22:14:36.6133333+00:00
Hendrix 2,690 Reputation points Independent Advisor
2 answers

what is the best way to create a square bar code using IMAGE in excel

using Excel, I have data in a cell that I want to convert to a square bar code in an adjecent cell

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-11-04T15:44:54.7333333+00:00
Kelliher, Timothy 0 Reputation points
edited an answer 2026-11-04T16:28:02.1933333+00:00
Ruby Nguyen 3,640 Reputation points Independent Advisor
2 answers

fix error when transposing an url link into an image

My file contains url link and I want to create an image based on a url address in the next column, but it has an error. Initially it appears Busy with a rehresh button, but it dissapears and remains #value with error. How can I fix this error?

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-11-04T11:03:35.6533333+00:00
Annabella Bucuresti 0 Reputation points
commented 2026-11-04T13:14:06.4933333+00:00
Annabella Bucuresti 0 Reputation points
2 answers

Sorry, there was a problem while trying to connect to your account. Error Code: 0x0

Has anyone run into this issue recently. We have Microsoft 365 Apps for enterprise - en-us install version: 16.0.20326.20100 installed on server 2022 Version 21H2 (OS Build 20348.5499). This is a persistent Citrix VDI with Citrix Virtual Apps and…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-09-14T13:49:08.03+00:00
Marcel Talmaggies 20 Reputation points
commented 2026-11-03T21:36:14.6633333+00:00
Marcel Talmaggies 20 Reputation points
2 answers One of the answers was accepted by the question author.

Pivot Tables not accepting new data

With each bi-weekly payroll run, I've been adding payroll data into my workbook that contains the running data and pivot tables for various categories--gross wage; FICA; etc. With the last payroll, the data is not refreshing as it has been lo these many…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-11-03T15:43:30.3766667+00:00
Joe J 40 Reputation points
commented 2026-11-03T18:32:34.71+00:00
Lin V 1,965 Reputation points Independent Advisor
1 answer

How can i access the event-by-event audit trail

I want to pull the event-by-event audit trail in excel and PowerPoint for things such as: each open/view each edit/save version-by-version changes sharing/access events who performed each historical action deleted/restored events a chronological…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-11-02T07:50:30.1766667+00:00
Van Der Watt, Christopher 0 Reputation points
commented 2026-11-03T15:21:29.5633333+00:00
Liora 3,285 Reputation points Independent Advisor
1 answer

KB5002665 says it's installed, but won't uninstall

After wrestling with the KB5002914 copy/paste issues in Excel, it took a few hours, but I was able to uninstall it and tell Windows Update to ignore it. Today I installed a new round of updates, apparently including KB5002665, the pseudo-fix for…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-17T00:39:18.64+00:00
Bithead 0 Reputation points
commented 2026-11-03T09:30:34.4533333+00:00
Eric 1708 6 Reputation points
2 answers

How to open an Excel file that has an IRM protection, but the old tenant is closed

I have the Excel file that has an IRM access control, but the old tenant is closed. How can I open or remove the IRM setting? Moved from Microsoft 365 and Office | Excel | Other | Windows

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-11-03T03:48:06.93+00:00
Autumn Ng 0 Reputation points
commented 2026-11-03T07:01:46.7066667+00:00
Jade Ng 16,535 Reputation points Microsoft External Staff Moderator
3 answers

Patch Regression: KB5002934 (October 2026) breaks copy/paste fix originally provided by KB5002665 in Excel 2016 MSI

Issue Description: The silent copy/paste failure in Excel 2016 (MSI) has returned immediately after installing the cumulative update KB5002934 (released October 13, 2026). Technical Analysis: Environment: Excel 2016 MSI (Traditional Volume License…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-14T16:11:30.66+00:00
Narciso Gonzalez 10 Reputation points
answered 2026-11-02T23:06:40.5833333+00:00
Hendrix 2,690 Reputation points Independent Advisor
2 answers

Stock Data Server Unavailable for Two Days

The server used to retrieve stock data has been unavailable for the past two days. Could you please provide an update on the issue and an estimated time for service to be restored?

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-29T02:44:05.43+00:00
Clover Keth 0 Reputation points
commented 2026-11-02T01:42:29.8466667+00:00
BabybooHN 3,810 Reputation points Independent Advisor
2 answers

Excel auto unhiding columns disrupting workflow

I am having trouble with excel automatically unhiding columns that I have hidden. This seems to happen randomly, and I cannot find a common point of failure. Sometimes it happens after only an hour sometimes I can go for four. The files I am working on…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-30T16:16:07.47+00:00
Brad B 0 Reputation points
commented 2026-11-01T21:09:17.38+00:00
Ruby Nguyen 3,640 Reputation points Independent Advisor
3 answers

2026 Microsoft word calendar template

Microsoft word opens 2025 calendar by default and there is no way to select 2026 calendar template. Where to find 2026 calendar template?

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-01-07T10:14:58.23+00:00
Zhao, Cheng (SSC/SPC) 25 Reputation points
answered 2026-10-31T01:30:04.3933333+00:00
william idsinga 0 Reputation points
2 answers

Using EXCEL to highlight dates past the date in the cell (not today)

Hi, I have a range of data on a spreadsheet used for customer contact. I have one column which has the date in which they were last contacted. I use a specific follow up pattern of sending emails at different intervals. I need to highlight the date in…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-30T10:27:12.9833333+00:00
Charlotte Guest 0 Reputation points
answered 2026-10-30T11:16:03.4533333+00:00
Marcin Policht 112.4K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

XLOOKUP not working in Excel, but only for me, not hundreds of others

My company put together an Excel form that uses XLOOKUP. The formula works for everyone else, but it does not work for me. It has to be some setting for my account because I have tried it on my desktop at work, at home and on my laptop with the same…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-29T18:15:41.33+00:00
Reyes, Janet 20 Reputation points
accepted 2026-10-29T18:23:35.04+00:00
Reyes, Janet 20 Reputation points
1 answer

Issue with using spreadsheets in Neota

Hi, I am currently building an application within Neota. The application takes info from the user, which is then inputted into the spreadsheet to run calculations. The output from those calculations is then to be displayed within the application.…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-27T16:16:08.6666667+00:00
James Hoey 0 Reputation points
commented 2026-10-29T15:25:57.12+00:00
Lin V 1,965 Reputation points Independent Advisor
3 answers

Excel 2609 (Build 20430.20092) crashes when opening files from OneDrive – Rtc.dll 0xc0000005

After updating Microsoft 365 Apps for business to Version 2609 (Build 20430.20092), Excel crashes immediately when opening Excel files stored in OneDrive. Environment Microsoft 365 Apps for business Excel Version 2609 (Build 20430.20092) Current…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-09-24T14:58:17.0866667+00:00
BAE DONGUK 10 Reputation points
commented 2026-10-29T13:05:23.93+00:00
EmilyS_726 34,010 Reputation points Volunteer Moderator
3 answers

Power Query "Expression.Error: Access to the resource is forbidden" when connecting to Exchange Mailbox on Excel Desktop client (Works fine on Web version).

Hello Microsoft Support Team, We are encountering a persistent authentication error across multiple user tickets within our organization when attempting to connect Excel Desktop Power Query to a Microsoft Exchange mailbox. Symptoms: Power Query fails…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-14T18:39:53.6766667+00:00
Sandeep boudh 0 Reputation points
answered 2026-10-28T18:13:44.3566667+00:00
Ashish Agarwal 0 Reputation points