21,097 questions

Sort by: Updated
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 20 Reputation points
commented 2026-11-03T18:32:34.71+00:00
Lin V 1,875 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,200 Reputation points Independent Advisor
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,530 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,610 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,710 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.2K 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,875 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
1 answer

Table formatting?

Hi there, I'm creating a spreadsheet so I can track our teams currency and competency across multiple different skills. So currently I have the 'Summary' Sheet with everyone's name on, I need this to appear across all sheets and when I updated/insert a…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-27T15:10:06.0933333+00:00
Bubblehead Jack 0 Reputation points
commented 2026-10-28T16:22:16.15+00:00
Lin V 1,875 Reputation points Independent Advisor
3 answers

Can't open excel on desktop app

I am unable to open excel via desktop app. I can only open it via the web. Can you please help?

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-27T09:54:13.2066667+00:00
Sasich, Michael 0 Reputation points
commented 2026-10-28T15:45:51.4366667+00:00
Julie Huynh 4,105 Reputation points Independent Advisor
2 answers

shut off flash fill

in a shared excel doc I don't want autofill to populate cells automatically

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-21T14:40:20.1333333+00:00
Cross, Thomas 0 Reputation points
commented 2026-10-28T13:03:59.9066667+00:00
Cross, Thomas 0 Reputation points
3 answers

Unable to deploy Claude for Excel add-in through Admin console

I am trying to enable the Claude for Excel add-in for my org and when I go to setttings > Integrated apps > Get apps and choose Claude for Excel, I constantly get a deployment error: "We are unable to initiate the deployment. To deploy the…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-05-06T21:34:20.4833333+00:00
Sergio De La Garza 5 Reputation points
commented 2026-10-27T22:07:52.02+00:00
Jake Reilly 0 Reputation points
3 answers

How to disable the new copilot floating icon in Excel?

Just opened excel today and it had awful floating icon for copilot. I have the ability to dock it/undock it, but not to remove it. I went to file>options, but could not find a tab for copilot to disable it. Help! This thing is going to drive me crazy.

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-05-08T20:50:53.26+00:00
Michael Watkins 20 Reputation points
commented 2026-10-27T13:51:30.0533333+00:00
Lee Donahue 25 Reputation points
1 answer

URGENT – Excel 2016 copy/paste regression after KB5002934 – Version 16.0.5574.1004

Dear Microsoft Support Team, I am experiencing a serious copy/paste issue in Microsoft Excel 2016 Professional Plus following the installation of the October 2026 security update KB5002934. The issue affects existing worksheets in important business…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-25T03:10:07.9+00:00
Árpád Bertalan 0 Reputation points
edited an answer 2026-10-25T06:37:25.8133333+00:00
Aetherin 3,520 Reputation points Independent Advisor
4 answers

STOCKHISTORY function not working

Hi, I’m having trouble with the Excel STOCKHISTORY function. I’m trying to use STOCKHISTORY to retrieve historical stock prices in two ways: Pull a time series of historical prices between two dates. Pull the stock price for an individual date, where…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-09-11T08:31:49.32+00:00
Arne 5 Reputation points
commented 2026-10-24T14:11:46.2833333+00:00
David Wohlschlegel 5 Reputation points
4 answers One of the answers was accepted by the question author.

adjust formula so not need updating

I am using the formula below that is working fine, but it requires me to keep updating the number of rows to include the cells with data. The number of rows will always be changing - sometimes more, sometimes less. Right now, there are 14 rows with data.…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-10-22T16:50:41.7033333+00:00
Megan F 120 Reputation points
answered 2026-10-23T06:24:41.19+00:00
Barry Schwarz 6,431 Reputation points